I haven't actually seen any genuine in-game shots of PS3 titles. Only FMV, pre-rendered, or 'this will look like this when we run it on the PS3 and not just on our dual processor SLI PC... honest'. Maybe its because the PS3 isn't finished yet, but the PS3 launch smells of the PS2 launch. 'Yes Getaway will look like this'. Come launch - 'oh errr, it looks like a PSone game with texture filtering, oh dear'.
I too had a PS2 shortly after launch. I've played Grant Turismo 3 on it quite a lot, but other than that no PS2 game has kept me entertained for more than a few minutes. I recently got an Xbox for free with a projector, and have found some of the games on it outstanding. While I appreciate the PS2 probably has some good games, I just haven't played one. Actually no, I liked Red Faction. That was a great game
Better on the PS2 than the PC as well. Either way I've been thoroughly disappointed with the PS2, and very surprised with the Xbox. The Live! service is an exceptional bonus too imo.
Will the PS3 be a success? Undoubtedly. Will it offer anything new (now that the 360 has launched)? Most definitely not.