I don't own NI Komplete (wish I did) but if you are willing to shell out the cash for it's really a great package crammed with all sorts of cool stuff.
However... just having access to nice sounding synths and samples will not change the fact even great sounds need to be mixed and mastered properly to translate well to other soundsystems.
The synths and sounds that come with SPlat are really good and you can do a lot with them but you are on Artist, the base package that doesn't really have all the good stuff (mostly older instruments which are still good but not top notch compared to the fancier stuff).
You can upgrade to SPlat for far less money than Komplete costs and get those synths. They aren't as good as having Komplete but with some elbow grease and knowledge you can do a LOT of stuff.
BUT... again, you need to know how to mix those sounds and perhaps more importantly how to WRITE a tune in such a way it naturally sounds good before you'll get anywhere near pro results.
As far as samples? I really would not rely on the included loops to create anything epic. They're old and kind of busted. Plenty of sites out there that offer quality sample/loop libraries for free/low cost.
If that's REALLY your thing learn how to do your own sampling and looping. I think even Artist comes with some sampling stuff like Cyclone (and maybe the Matrix View). Groove Clip Looping is another area that avoids all the fancy sampler type stuff and allows you to do the same thing right in the Track View.
So... I'd say...
First and foremost use youtube search to find some general mixing tutorials or get a Groove3 monthly pass to learn about mixing fundamentals. You can ask mixing questions here on the forum too in the Techniques area. Tons of helpful and experienced pros down there.
Second, explore the tools and synths you currently have with Artist and how to tweak them. I'm not sure exactly what comes with Artist but it is a limited package so consider upgrading to Professional or better yet Platinum. This includes exploring FX which can have a HUGE impact on even crappy generic sounds. There are two vids by SWA/Karl Rose in the Cake store. One I think is called "Sonar X2 Workshop FX" and the other is "Virtual Instruments Revealed". They are great walkthroughs of ALL the synths and effects that were included in X2 Producer (almost all of which remain and only a few things have been really added so it's still relevant). Karl's "SWA X2 Complete" is up on youtube for general stuff.
When I first got started I thought I needed to invest in a TON of extra instruments and FX. Once I started learning how all the stuff I already had with Sonar worked many of those things became unnecessary. Saved me a fortune (that I don't have BTW).
Now I KNOW the things that are missing or maybe not as good as third party stuff and what's actually worth spending money on outside of the SPlat package.
Anyway... you get the point. You can do a lot more with some knowledge and simple tools than throwing a bunch of cash at expensive third party stuff and just poking away at it hoping something willl sound good.
Cheers.