I've been stuck in Prime 1 and 2 for probably years now. But the thing is, once you get stuck in those games, and you stop playing for like a week and start it up again, you've no idea where the **** you are and where you're supposed to be or what you're supposed to do. You look at the 'map' and its like you're looking at the Antilife Equation. Then the game may 'tell' you where you're supposed to go by showing you on the map but it doesn't tell you how to get there and what you're supposed to do and most of the time you can't go straight there anyway. Then there's that boss in 2 that has the screw attack..screw that boss.
I'm not really stuck in most of my games, I just get incredibly bored. I was playing Castlevania SotN and died, and I just quit and went to something else. It's not that I can't get passed it or whatever it's just that I get bored so easily nowadays. I have a huge backlog of games that suffer from my lack of patience and boredom. I still get around to playing them though. I remember buying MGS3, only ever got to the Sorrow. Stopped playing it for over a year and then I picked it up, now it's one of my favorite games of all time lol.
But if there is a game I'm currently stuck on, it would be Dark Souls. Amazing game, loved the first one to death, but this one pisses me off. Or rather I piss off my self when I play this lol.