Here's some of my favorite looking games (aka I've played them and saw them in action). Not sure which one's the best...
Sonic and Knuckles (Genesis)
Yoshi's Island (SNES)
Bioshock (360/PC)
Mario Kart 64 (Nintendo 64)
The Legend of Zelda: Wind Waker (GameCube)
Resident Evil 4 (GameCube)
Metroid Prime (GameCube)
Any Iga style Castlevania (PS/GBA/DS)
Muramasa: The Demon Blade (Wii)
Okami (Wii)
Super Mario Galaxy 1/2 (Wii)