Vagrant Story wanted so badly to be my Kryptonite. There are so many mechanics stacked on top of mechanics and it's just an absolute chore to play if you're not reading a guide/wiki and looking to tick a bunch of boxes and "git gud" in a very specific way. The story, setting, art style, etc is great - the game is not.
I wasn't about that quitting life though, so I did complete the game: I beat the entirety of Vagrant Story using a broken dagger and ignoring 99% of all mechanics. I fucking killed every single thing in that game past the first, say, three hours, hitting them for 1 damage. Including the end boss.
I learned of the concept of "grinding" in an RPG thanks to FF7. There's a boss in or around Nibelheim, I think - maybe related to a library - that I couldn't beat, so I spent probably an hour doing random battles to get stronger and took it out. In retrospect I probably got too strong because I don't remember the rest of the game putting up much of a fight at all.
FF7 has one of my most memorable "Well, that was entirely underwhelming" moments, too. I took out Ruby Weapon during my original stint with FF7, but wanted to keep playing more games in the series as I was new to it. So I attempted Emerald Weapon only a handful of times and then set the game aside figuring I'd come back through all of them and mop up all of the ultimate bosses.
I came back, I don't know, two or so years later and did some grinding in the final cavern. Got to maybe lv92 or so, up from maybe high 70s? So I set up the party's Materia in a loose configuration, something where Aire Tam Storm would only do like 5~6k, and wandered over to see how long it took to get killed. Wasn't paying super close attention and chatting with a relative while in the fight, and around 15 minutes in... it died. Just, it fucking died?! I was so blown away by how dumb and empty feeling it was that I genuinely don't even remember if I bothered saving afterward.
People love it, but that game wasn't balanced very well at all.
I don't remember anything specifically like this, but I hated just about everything about the game regardless.
In the actual final mission I got caught up for a good 90 minutes because the game just felt like pissing me off, and I got pretty close to setting the game down for a while. You're basically riding a dirt bike and are supposed to hit certain time milestones and perform certain jumps to complete the narrative setpiece, and like... there's a random rock, or stray geometry, or something, in the lead-in to the final ramp. Every single time I was lining up to hit the ramp at the appropriate speed I would hit this fucking rock, lose complete control, and fail the mission. And have to do the entire thing over again, to reach the same spot, to not be able to tell exactly what I was hitting, to hit it again and fail.
...There's a reason I never even looked at GTA5.
