Speaking of Final Fantasy games, I find I don't like a lot of the earlier ones because they either get weird or the pacing changes completely around the midpoint.
-In FF VI, even though I love the game, I find the pacing comes to a grinding halt once Kefka ends the world. Maybe that's kind of the point, but before that, you were pretty much racing from one point to the next as the plot was incredibly engrossing. After that, it's basically a Final Fantasy version of Pokemon as you collect all your friends and then go fight the bad guy.
-In FF VII, I feel it's similar once Sephiroth calls down Meteor. Then you're just grinding until you decide to go after him in his bubble fortress.
-I was digging FF VIII up until the introduction of time travelling witches. Once that aspect as introduced, I found the rest of the story and plot went totally south. Not to mention a anticlimactic finale where you jump to the future but there's not much to do there except fight the witch.
-I would've loved FF IX more if it had stayed consistent with the fantasy setting. But then a spaceship and alternate universes are introduced, so it becomes more of a sci-fi.