PS1 = Oddworld: Abes Oddysee (& Exoddus). I find these to be the most beautiful games on the PS1, the best looking side scroller of its era.
PS2 = God of War II. Came out after all the next gen systems had already released and it still held its own visually.
PSP = God of War: Ghost of Sparta. Can compete with even the best looking PS2 games.
PS3 = God of War III. Yeah, God of War: Ascension looks slightly better but GoWIII was the first PS3 game to blow me away and only GoW:A looks better, nothing else has topped it, not even UC3, KZ3 or TLoU.
Xbox = Splinter Cell: Chaos Theory. Always thought this looked stunning, the only game I played on the Xbox that wowed me.
Xbox 360 = Gears of War (series). The 1st introduced me to next gen visuals, its successors got increasingly better looking and GeoW:J is very good looking.
Gamecube = Luigis Mansion. Always loved the look of this game.
Wii = Super Mario Galaxy 1 & 2. These are very good looking games, it's a shame hardly any developers tried to use the Wii's full potential.