What game did you play a ton of in the past, that you were never good enough to beat?
My two:
Very cliché, I played Ocarina of Time a ton as a child, have memories of playing it both on N64 as a wee child and on game cube as a less small child. Never got past water temple even with the game guide.
Yu-Gi-Oh forbidden memories. Played the crap out of that game on play station, constantly playing on free play praying for the cards I would need to get further. I was never able to beat more than 1-2 of the high mages. Watching speed runs on the game it turns out I was never ever going to beat that game as a kid. The final 6 are just disgustingly brutal.
Pretty much all of them... I have so many memories of old 80s computer games where all I remember is level 1. It appears that I was terrible and perfectly happy with that.
Ghouls 'n Ghosts. Absolutely loved that game. I played it constantly. Even when i got a new game, i would always go back to that cursed game. I don't even remember how far i got, but i did not got far at all.
Daggerfall. I played that game to death and didn't even make it past the third or fourth quest.
Eventually I'd give up and just wander off to do whatever I felt like. I must have visited every major city and country, but never set foot in one of those annoying dungeons :)
All those old LucasArts games (Day of the Tentacle, LOOM, Indiana Jones & the Fate of Atlantis, Sam & Max, Grim Fandango, Full Throttle, &c) and similar adventure games (Kyrandia, King's Quest, &c). My mother played all of them and beat them, and while I watched her play I never really managed to finish any of them without looking up guides.
For me its factorio. I always start, get into problems, realize I fucked up the layout and am thinking 'better just start fresh'. So I have a couple hundred hours in the game, but I never completed it.
GTA 3 / Vice City. My brother had a PS2 and would let me play. I never bothered with the story / campaign, I just liked to wonder around, steal cars, and drive. I enjoyed using cheat codes to spawn tanks and get full wanted level and outrun the cops.
I could never beat the Harry Potter games because there are parts where you need to trace certain symbols at a certain speed to learn a spell which are required to progress through the game, and trying to get both the hand dexterity and mouse dexterity to follow through is worse than button-mashing levels.
The Water Temple was a nightmare of a level. Easily the hardest point in the game. If you stick with it, the everything that comes after it seems relatively straightforward!
That being said, having finished the game multiple times many years ago, I played through Breath of the Wild then went back to Ocarina of Time, and it felt very dated. Lots of nostalgia, but the control system is that of a very primitive game by today's standard for open worlds.
As for your question though, The Lost Levels in the Super Mario Allstars game. I've never gone back to it after all these years, might be worth trying again now with fresh eyes :)
Diddy Kong's Quest for the SNES. I always got stuck in K.Rool's Keep, got frustrated, took a break, forgot the game existed for a couple of weeks/months, and then started over from scratch when I realized that I wasn't used to the controls anymore.
Vagrant Story was extremely confusing for a kid that just started learning English as second language, but I really loved the character designs and tactical real time gameplay.
Now I know there were several systems I didn't understand but also the game itself hides it from you like your weapon slowly switching it's damage type according to what you hit, and also the story is fantastic.
Tazmania for the Sega Genesis. I didn't like the game all that much but I didn't have a lot of choice back then. I don't think I ever passed the mine stage.
This doesn't answer quite what you asked, but what comes to mind is The Legend of Zelda: The Adventure Of Link for the NES.
I had a Game Genie as a kid. And for some reason I could not get past the boulder to get out of the first overworld area.
It wasn't until quite a few years later that I figured out some of the Game Genie codes in the official Game Genie code book could have permanent affects on your save file. I had apparently gotten the hammer (which was what was required to break the boulder), but before breaking the boulder, I used a Game Genie code to swap the Hammer for some other item I wasn't supposed to get until later in the game. So, I was stuck without the ability to break the boulder.
More to what you were asking, The Adventure Of Lolo was a good example. I was pretty young when I first picked it up. Decided it was too hard, and basically never touched it again until adulthood. In adulthood, I loved it.
Obsessed with Legacy of the Wizard as a kid on my NES. I didn't even realize the goal was to get crowns until I revisited as an adult. I can still hum 5 or 6 different scores from the games soundtrack 30 years later.
I'm not a gamer, but I got really into ff8 in high school. I tried a bunch of other rpg games back then too, but I could never beat them. I always got to a point where I wasn't strong enough to win a battle but didn't want to go back and grind, so I'd eventually give them up.
Magic Carpet was incredibly fascinating. A whole planet that you could explore and influence and even modify terrain on? Every kid's dream, even given proof by Minecraft's popularity 20 years later. Could never get past the first several levels though.
Finished the game recently after giving it another go, no wonder only the beginning is kid-friendly. The later levels are devilish puzzles in difficulty. If you do not figure out the exact sequence of actions necessary to solve them, you die! Their open-world nature is only a masquerade to trick you into complacency.
None. If I enjoyed a game enough to play it a ton, I will eventually beat it. And not just beat it, but get 100% and all the achievements when possible.
The only games I played a ton but didn't beat are open world games that don't have a set objectives.
The first two gothic video games. The first one started to crash when I entered a specific area and the second one I don't even know why I didn treat that one
Sega Game Gear Sonic 2. Had a boss that you had to beat with cannon balls that bounced at you down a hill. No instructions or clues, and no rings in the act to save you. Just don't die from the same balls.
Final Fantasy. My friend and I played it cooperatively, and we made our team four red mages. There was a mini boss in the final dungeon we kept getting destroyed by no matter how much we would go back and grind levels. We finally gave up. I couldn't beat Super Mario Kart either, but i didn't actually get to play that as much.
Sonic the Hedgehog 2. Most Sonic games are easy, but Sonic 1 and 2 aren't. Actually, I've beaten it as Knuckles, but never as Sonic (therefore I've never beaten it as it was in it's original release,) I can't get past a specific jump in Wing Fortress Zone.
Minecraft is less that I'm not good enough and more that I get bored around the time I first get to the Nether.