How about we go with this. Everyone is obviously not going to agree which game is the best looking game on console because everyone has a bias. I myself think Crysis 2 is the best looking console game to date. I've been playing it and its amazing. Other believe Killzone 3 still holds the title and a select few think Uncharted 2 still has the title with probably others thinking God of War 3 has the title.
The one thing we can all agree on is Crytek has done something amazing in that their first foray into console gaming and has made a huge splash and Crysis 2 can be argued to be the best looking. CryEngine 3 really is everything they said it would be and Codename:Kingdoms is going to definitely be one of the best looking console games this gen when they get a second crack at making a console game.
