Pianos are my bread and butter, and I agree with those that are saying True Pianos is a good choice. They have a great modelled sound, and the hit on your CPU is so low you could host a piano quintet without breaking a sweat. However, I do think to get the best 'Grand Piano' sound from TP you will have to pay for the Atlantis module. (hint: it's worth it). Whenever I am starting to write or record a piece, I almost always use True Pianos, and often never bother switching to another instrument. This is a great sounding piece of software and I think Sonar is a much better piece of software from having this program in it.
If you are looking for an good all round Grand Piano sound for free, look no further than the pianos installed with Dimension Pro (or Rapture Session now). They are not necessarily the best out there, but if mixed with other instruments as part of a band, the sound is more than passable. (and they're free!)
I will add that if I want a true piano sound I will mic up the acoustic piano. There is no comparison as far as I'm concerned, I've yet to hear a model or sample that comes close when compared side by side to a real acoustic piano.
I will then add, that the wording here is important. You notice I wrote "when compared side by side". That's because sometimes it is almost impossible to tell just by listening to a piece on it's own, whether it's a real piano or a software one when played and mixed well.