My list is rather short, as I don't enjoy playing through games in one sitting. I much prefer playing them over a period of time and fully enjoying them, the adventure, the soundtrack and all of the features.
This is also how I prefer to play most of the time: Start the game up, play for a few hours, take a break, and return at another time, which is hardly ever predetermined. But that only goes for long action/adventure games such as Zelda or Mario.
Star Fox 64 (45 minutes) (N64)
Yoshi's Story (1 1/2 hours) (N64)
Mario Kart 64 (2 hours) (N64)
Legend of Spyro: A New Beginning (replaying the events through my head, the total likely sums up to 5 or 6 hours) (PS2)
The Subspace Emissary (Adventure/Story Mode) on Super Smash Bros. Brawl (6 or 7 hours) (Wii)
Mario Kart Wii (5 hours to complete all the cups, minus all the annoying credits scenes)
That's I could probably add more to the list, but my gaming experience is so limited that I can barely remember every one-sitting game I've played. But if I think of more then I'll post them as well.