It's not odds or even. You separate FF by era.
The first six FFs are classic FF. They share the core pillars of 1. exploration, 2. leisurely menu based combat, and 3. charming medieval fantasy aesthetics. Starting with FF6, the exploration aspect starts being lost and FF becomes less and less games and more and more moviegames where you walk down the corridor to reach the next cutscene.
In the PS1 FF games, the world map gameplay is barren. It is noticeably different than classic Final Fantasy games. I'd lump FF10 with the PS1 games as FF10 is the last game that vaguely feels like Final Fantasy. FF10 removing the world map was a formality. After that, the games after are so utterly different that they feel like they are from different franchises. FF12 loses a lot of aesthetic charm due to its combat system, which does not have the nice presentation of prior FF games where you have camera angles and characters striking cool poses and being dwarfed by huge menacing monsters. The narrative is also very dry and does not feel like a fun FF adventure. FF13 recovers somewhat in cool battles department, but completely ditches the medieval fantasy aesthetic for futuristic ones. Then you have FF15, a moviegame with button smasher action combat set in California and has a photorealistic art direction. Versus XIII seemed to be a lot more interesting (story about the mafia, set in a nighttime fantasy urban city, more stylized art direction), but still didn't feel like Final Fantasy.
FF X-2 was acquired taste as long as you don't take it too seriously.
FFX-2 is the first serious misstep with the franchise. Final Fantasy fans expected a Final Fantasy game. They bought it on launch day, put the disc into their PS2, watch the opening cutscene, and then threw the game into the trash. Final Fantasy fans do not want K-PoP idol trash.
It was made massively worse by introducing Vaan and Penelo SKY PIRATES.
Vaan and Penelo were one of the few redeeming factors of FF12. Outside of them, I found the cast to be dreadfully dull, which is exacerbated by the fact that you have to put up with these doorknobs for 50+ hours. I found several side characters to be more likeable and wish they were in my party instead, namely Larsa, Al-Cid, Doctor Cid.
if republic would be these nasty people who attacked that kingdom to bring them democracy, well then the story would be FAR better.
I wonder if Rozaria's conspicuous absence was due to the game's troubled development. Rozaria is also an expansionistic empire like Archadia. The story begins because of the threat Rozaria poses to Archadia. That's why Vayne began trying to develop superweapons. When Ghis' airship fleet blows up - sending a huge chunk of Archadia's military strength down the toilet - Rozaria
immediately begins maneuvering their fleets into a position to attack the Empire, which then prompts the Emperor to commit suicide so Vayne can cut through the bureaucratic red tape and take defensive measures immediately. The game we got has a fairy tale happy ending. Archadia is still in a vulnerable position and it is still in Rozaria's best interest - and their motives - to continue the push. Ash rejected Nethicite so Dalmasca is still powerless. Even if Larsa relinquishes control over Dalmasca, Roazaria is just going to take it anyway and there is nothing Ashe can do it about it. Even if an armistice happens now, the two superpowers are going to come to blows in the future eventually.
FF XIII they did something.
The game had outstanding visuals and a great soundtrack, but it did not fit what Final Fantasy fans wanted (medieval fantasy adventure, exploring a world). Combat was also fun. The corridors and the item management were nuisances but nothing crippling. I think the big reason why FF13's reputation is in the gutter is because of the widespread adoption of the internet, which means that the opinions of gaming journalists and youtubers had power. IGN and Spoony sandbagged FF13 and their opinions were regurgitated.