If you are buying already, I think the top version of Sonar (Platinum) still comes with Addictive Drums 2 which is a great drum program for acoustic/real drums - it comes with three kits and lots of midi loops and you can obviously edit the loops in Sonar.
The programs we're talking about will occasionally work as stand-alone but mostly you'd open them within Sonar, they're called plugins or virtual instruments or sometimes VSTi (Virtual Studio Technology instruments, a standard devised by Steinberg).
Kontakt is pretty much the standard for software samplers these days. You can buy it separately or as part of a bundle called Komplete which comes with a bunch of other sound expansions and other software synthesizers and fx. Currently the manufacturer, called Native Instruments, is holding a sale I think.
Altogether you'd be looking at quite a lot of money, around 600 for the top Sonar version and another time something like that for Komplete, even with the sale. M Tron Pro is cheaper but it also depends on how many expansions you want with it. With Sonar comes a basic version of Melodyne which is an awesome vocal editor (can also be used for other stuff) that you may want to upgrade for another 200 euros or so. It's really easy to spend your money these days :)
But still a lot cheaper than buying a Motif or Triton ten/fifteen years ago. And obviously you can go step by step, you could get a simpler version of Sonar, or you could get the top version but wait with buying Komplete or Kontakt (because it already comes with loads of stuff).