FF7 ending was great. Mainly because the ending wasn't a generic "the good guys win". The heroes just watched as things beyond their control took place. Without the retcon of Advent Children, up to that point I'd assumed Holy whiped the humans from the earth in order to save it from Meteor and for it's own survival.
FF8 was just that, an ending. FFX was good mind you
Hmm, pie.