Concurrence is rude nowadays, releasing a mmorpg has become super hard, I couldn't even mention a good one since 2004 (wow/dofus). In recent ones, I've heard Neverwinter is not so bad but it's kinda p2w, you have also Rift planes of idk and Guild Wars 2. I never played Final Fantasy so I couldn't tell.
I'm not up to date with the one Amazon develops, New World, but it looks like wow so much from what I know
You got Star Citizen if you think you won't die before its release, in its current state it's unplayable but if it was bug/desync free, it would be a great one even if it still lacks of content