Acoustic Guitars: RealGuitar (MusicLab)
Piano: Ivory II Grands (Synthogy)
Electric Guitar: Option 1: RealStrat and RealLPC (MusicLab). Use with GuitarRig or Amplitube
Option 2: Electr6ity (Vir2) I like MusicLab WAY better, but the Vir2 thing is less expensive, has more guitars, and a simple amp simulator.
Electric Piano: I use the SI-Electric Piano that came with Sonar a lot.
Bass: I use the SI-Bass that came with Sonar (or an external synth). With this, be careful with some of the finger bass samples--they have fret buzz.
Drums: Session Drummer 3 that came with Sonar. I have bought some extra kits.
I also have Vir2's Acoustic Legends HD for acoustic guitar, banjo, mandolin, and ukelele. It is not nearly as flexible for strumming as RealGuitar, but is good for adding a second strummed guitar when the chords are not complex. It is good for solo guitar lines or finger picking, and I use the mandolin a lot.
I also use some guitar, bass, and drum sounds from EastWest's FabFour, but they would not be your all-around bread-and-butter samples. One of the best samples in FabFour is an acoustic guitar sound from The Beatles "Blackbird."
If you buy Kontakt 5 you will get a lot of instruments and they will mostly be good. I personally prefer to pick a smaller number of the world-class sample libraries instead of one pakcage with 1,000 sounds. My reasoning is that I will have piano, bass, drums, and guitar in almost every song and they will be out front. If the rhythm section is not good, nothing can save the track.
If you ask about orchestra, I will give you a really long answer.