The Legend of Zelda: Wind Waker, LoZ: Twilight Princess**, LoZ: Four Swords Adventure***, LoZ: Collection****
Ikaruga*
Super Smash Bros. Melee
Eternal Darkness: Sanity's Requiem*
Super Mario Sunshine
Resident Evil ("REmake")**, Resident Evil 4**
Luigi Mansion
Killer 7*
Pikmin**, Pikmin 2**
Resident Evil 2, Resident Evil 3
Mario Kart: Double Dash
Viewtiful Joe
Metroid Prime**, Metroid Prime 2**
Metal Gear Solid: The Twin Snakes*
Paper Mario: The Thousand Year Door
Edit: A few that slipped my mind the first time.
Kirby Air Ride
Soul Calibur 2 (With Link as a bonus character

)
Sonic Adventure DX, Sonic Aventure 2: Battle
*Haven't played these myself, but I've heard a lot of praise for them.
**Also available for the Nintendo Wii. Up to you which version you want to hunt down, but it's pretty much agreed that the Metroid Prime Trilogy is the best version of those games.
***FSA can be played single player, but the idea behind it is letting up to four people play a Link to the Past style Zelda game. For multiplayer, you'll need to aquire three Gameboy Advances and a cable to attach each as controllers. Never played this one myself either.
****This was a promotional item. It's Ocarina, Majora, and the first two Zeldas on one disc. You'll probably have to look online to find it.