The final battle with Sephiroth in FFVII is just stupidly designed. Specifically, his "Supernova" attack.
Supernova does a significant amount of damage. That's fine. He casts it about seven times over the course of the battle. That's also fine. The goddamn cinematic for it is TWO minutes long every time. That is ridiculous.
It's mildly entertaining the first time, but by the end of the battle, you will have spent fourteen minutes watching that same cinematic. Worse yet, the cinematic itself is incredibly stupid; firstly, it reveals that the game takes place on Earth; secondly, it implies that Sephiroth destroys the entire galaxy (multiple times no less); and thirdly, it is more powerful than Meteor is to begin with. Everything about it just suggests that no thought was put into it besides "lulz this is kool". And just to add a bit more stupidity, for all the power that its cinematic suggests it has, Supernova only ever removes a set percentage from your health, meaning it can't actually kill you.
Here [http://www.youtube.com/watch?v=Ye0dJhSH_LU] it is, for those who haven't seen it or don't remember it. The game itself is great, but this makes the battle so frustrating that it just leaves a really bad taste in my mouth. I wouldn't say it ruins the game, but it certainly makes me think less of it.