We haven't seen enough of many of those games, but based what I have seen so far I think The Last Guardian and God of War 3 are the most promising with regard to art direction and atmospheric environments.
With regard to realism it looks like Gran Turismo 5 will take the crown.
Crysis 2 looks great, but judging from what they have shown so far it has less atmospheric lighting and less impressive character animations (awesome hit impacts and death sequences) than Killzone 2 (which has awesome parts like the dropships dropping off helgast and reinforcements).
FF XIII's cutscenes also look amazing. Parts of Heavy Rain look very good for a realtime game as well.