Yeah, FF7 was great until you find out Cloud is genetically-engineered and then the whole thing with Meteor.
You'll love FFX. It's the only video game that's ever made me tear up (the wedding scene, and NOT for the reason you think). And, even better, the ending actually makes sense. Plus, the sphere grid method of leveling up is really cool and innovative. I wish more games did it like that.