You know what's weird? This thread was trolled on the VERY FIRST REPLY. The XBox360 thread still hasn't been trolled. And I thought PS3 fanboys were supposed to be the worst?
I posted this here because I don't want to derail the XBox360 thread, and this thread has already gone to hell.
But to reply to the OP: I think Killzone 2, Uncharted 2 and God of War 3 are 3 of the best looking console games so far, and show that if you can work with the PS3, it's capable of some amazing visuals.