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.
I beat Super Mario Bros. in one sitting. lol I didn't use any warp points. I also beat the lost levels in one sitting. Both those were on the Super Mario Bros. Deluxe Game Boy Color cartridge. I would have beat Crash Bandicoot 2 in one sitting but it froze on level 21. I know I can beat ALttP in one sitting too. I just haven't had the time yet.