Personally, I am guardedly optomistic. I hated FF8 and 9, and from what I have seen, FFX isn't that great. FFXI is of course, someone's sick idea of a joke, and FF-X2... well... I might prefer playing Tomb Raider (and I HATE Tomb Raider). Basically, that covers all the recent Final Fantasies. But to be fair, I haven't played FFX yet. I am just going on word of mouth and plot details I have picked up here and there.
Final Fantasy IX I thought had some real potential. The character and art design were excellent, the soundtrack was quite nice, and the combat system was awesome. However, a boring plot and weak characters killed the game for me. It became my second least favorite Final Fantasy after that. (behind Mystic Quest, but after FF2j)
Final Fantasy Crystal Chronicles has some real similarities with FF9, and I respect that. I just hope it does it right this time around. I want to see a classic Final Fantasy once more.