Silent Hill, the RE games, Endless Ocean 2 (stunning), Conduit, Goldeneye, CoD.   Final Fantasy:Crystal Chronicles: Crystal Bearer had some nice visuals but not as photo realistic and, of course, the gorgeous Xenoblade.

Soul Calibur Legends and Castlevania:Judgement - while forgetable games where visually pleasing

And Prince of Persia: Forgotten Sands

Definitely Silent Hill. That game had awesome graphics, really atmospheric.

Prince of Persia: The Forgotten Sands (runs at 60 FPS too)

Still unhappy that I'm the only one who really cares about this game. It was awesome.

Xenoblade by far for environments, but not characters.

Crusin'

But seriously, I think the Resident Evil rail shooters are the best at realistic graphics:

The Conduit, Goldeneye, Xenoblade

You're not the only one.  I really enjoyed it.  Definitely one of Wii's most overlooked and under-appreciated games.  

It's definitely one of my top ten Wii games. I'd put it up there with The Sands of Time in terms of level design.

Most have been mentioned, but i thought (dont laugh) that Medal of Honor Heroes 2 wasnt a bad looking Wii game, especially in 480p.

monster hunter tri
super mario galaxy 1 and 2
donkey kong country returns
legend of zelda : twilight princess
xenoblade
last story