I'm not sure if this is cheating: I thought Sonic Adventure 2 was The Best Sonic Game (I didn't played it as a child) I played it a few months and I thought it was atroucious, the Sonic stages were the most fun stages but they were still not that fun (except City Escape). Ever since I tried to give it chances but it's still a bad game.
Another game that I thought was great was New Super Mario Bros Wii, This game is only good when you play multiplayer, single player it's boring (I played it single player though) and I would even say, my own game (Darnell) is better. Super Mario 64 DS I beated it like 20 times when I was a child, coming back to it, the controls ruin the entire game, with the circle pad patch is A LOT MORE bearable but the camera sometimes is even worse than the N64. To be honest when I was a child I didn't played that much games and the ones I played were good ones.