The Ultimate Grand (X piano) was really good for 2004, quite realistic, although I think a bit indirect sounding.
If you get a SRX 06 Complete Orchestra in addition, you get 400+ more samples and a very good orchestral supplement for the soundset. Or for rock/pop purposes maybe SRX07. (I wouldn't recommend the SRG-01.)