This is 2005-2008 and some of these games are as late as 2013 (AC IV)
And a heap are Gamecube/Wii games... And they weren't ever graphically intensive titles.
Gears of War 2.
Crysis: Warhead. (Best graphics of any game ever up to that point.)
Little Big Planet.
Metal Gear Solid 4.
Mario Kart Wii.
Super Smash Brothers Brawl.
I must reinforce that visually the Wii fell short of the 7th gen platforms, the consoles visual output falls inline with the 6th gen platforms... But listed three games that looked okay for that platform specifically.
Realism is dull to me overall so I look more at a style perspective. Some of the best looking games that had a realistic look to me aged as well as milk left out on a hot summer day. So they impressed me with their style and still hold up today. Realism to me is about the most overused and dull aesthetic in gaming. So I mainly listed games I thought had a lot of style. Also, I did not list a single Gamecube game.