Final Fantasy 9 is the most overrated final fantasy game.
Final Fantasy 8, single handedly made me a fan of RPGs', not 7, though I loved aspects of 7 and I played that and a few other RPG's before hand, I much prefer the advent children additions and onwards, the 7 remakes are what the OG should have been and I'm glad it got remade because of all final fantasies, that needed a remake the most, as it aged like milk outside of the music and designs.
9 gets heaps of praise for some reason thought itr's objectivel worse than 8 in every way.
It has a simpler story and is more straightforward than 7 and 8. I also didn't notice that it was loved by anyone till I saw people mention it online. I am willing to bet it was their first final fantasy.
A common reddit post is "when does FF9 get good?", "How much longer do I have to play through 9 before it gets good?", I tried playing through it three times throughout the years and I stopped playing each time.
I say that as someone that finished, 7,8,10,13,13-2,lighting returns and all the kingdom hearts games, and all dragon quests except 9. I''m quite seasoned at RPG's in general and I thought FF9 had bad character designs, crap level layouts, really drawn out combat and also Nobuo Uematsu's worst soundtrack, add to this that it's written exclusively by Sakaguichi, whom isn't a great writer and the better written final fantasy stories are written by someone else, anyone else really. Blue dragon had great music, character designs, good music and a absolute ass story, written by Sakaguichi.