While I would agree with the OPs very subjective opinion on FF7 NOT being the best, I would consider it the most overrated rpg of all time. Meaning it's not a BAD game, but it most certainly is rated/valued a BIT too highly by most these days. All it really had going for it, was FMV that took up 3 extra game discs, that for the TIME, apparently impressed the pants off of people. The game itself could have been done on one disc, or for that matter, if done right, could have been done even on an N64 cartridge.
FF9 was the best of the PS era FF games, for sure. But I would strongly disagree that that was "THE BEST" either.
To this gamer, the height of the Final Fantasy franchise was FFIV through FFVI. Then again, that 16-bit era of gaming was the prime of rpgs, I feel, anyway. FFIV-VI, Mystic Quest (unfairly derided but still fun game), Chrono Trigger, Breath of Fire, Phantasy Star, Illusion of Gaia, Secret of Mana, Shining Force, Secret of Evermore, Landstalker, Beyond Oasis, Paladin's Quest, Mario RPG, etc. etc.
To me PERSONALLY, FFIV will always be the absolute best rpg ever made. Amazing story, soundtrack, characters, well-balanced gameplay, sprite-based graphics that hold up even now, you name it. FFVI was great too, but FFIV just has that "something" that made it really special to me.