BenVTrigger on 12 June 2011
From what I've played these are the best looking games on console. In no particular order.
Uncharted 2
Gears of War 3
God of War 3
Killzone 3
some other notible mentions are Crysis 2, Final Fantasy XIII, Alan Wake, Dead Space 2, and a few others.