There are a couple of N64 games that come to mind. I'll mention Cruis'n World. Back then, I could play for hours a day, working to unlock the ultimate car in the game. It was... decent for its time. Now, looking back, it has that cheesy win screen with the trophy girl, and the female announcer, and is just a boring game.

Teenage Mutant Ninja Turtles II: The Arcade Game is another one. I used to love any beat-em-up back then. I rented TMNT2 more times than I can remember though. Never really got past the 4th stage back then though. Now, when I go back, it's incredibly lame compared to even other NES beat-em-up. Not to mention Shredder being one of the most broken end bosses of all time.