I've enjoyed every FF that I've played, and I've completed 4 to 9 inclusive. 7 always stands out for me, but 9 was good. Very good. Not my favourite, but certainly not my least favourite either.
Lots of good ideas and characters, a nicely involved plot. I have reasons for not considering it the best, but I won't list them here.

FFIX is just neat.