To be serious for a change, Crysis Warhead.

Consoles: Uncharted 2

Upcoming: Let's not go there.

on PC
crysis and mirror edge on highest settings(resident evil 5 as well)


on consoles:
Uncharted 2
Killzone 2

Zelda WW or Valkyria Chronicles.

Heavy Rain and GOW3.

Overall: Crysis Warhead
Consoles: Uncharted 2
Upcoming: Pretty sure that Crysis 2 PC version

Hmmm. . . I think technically KZ2 has the best numbers (for a console, my PC can't even look at Crysis), but I think artistically it looks like ass. Uncharted 2 has unparalleled animation, and a lovely color palatte. I think that Mass Effect is my favorite looking game, my female Shepard is uncomfortably good-looking.

Upcoming, well you can guess that I think ME2 will be amazing to look at. But I also think Heavy Rain will be somthing to see as well, as far as character models and environments go. Man it's great to be an all-console owner again!

On PC I don't know, On the consoles its Uncharted 2 , Killzone 2 , MGS4 , Modern Warfare 2, In my opinion these are the top of the game. They mix textures with rich color, Uncharted 2 is Amazing, its the best of the best. When God of war 3 arrives, because the demo looked good and it was old code, The game looks much much better, it will also be one of the best.

Crysis probably, with some of the other mods and stuff.

Art direction - Modern Warfare 2, Resident Evil 5 and Uncharted 2.
Tech graphics on consoles - Uncharted 2, Killzone 2 and Gears 2
Tech graphics on PC - Crysis, Stalker: Clear Sky and Crysis Warhead

Overall - modded Crysis, soon to be overtaken by Stalker: Call of Pripyat

OKAMI!!! Jokes aside, KZ2 probably since i never actually played Crysis.

no but seriously, Okami must rank up there in my top games for graphics.