ESO has awful combat. Since it’s fundamental to an MMO, I would skip it. That goes for a lot of the existing console MMOs that are free to play.
FFXIV has better combat, but not until you’ve gotten to at least level 50. Prior to that, it’s really, really bad. That said, the boss encounter design is best described as choreography. Bosses are scripted to perform certain actions on what is essentially a timer, and you react accordingly. I got what I wanted out of the game after near a decade, but the combat design is just too predictable. I prefer reactive, dynamic encounters which FFXIV doesn’t offer and likely never will. Every boss encounter will play out exactly the same, every time, without fail, because predictability is core to the entire game’s design. Every patch, every expansion, is predictable. The combat is mid tier, IMO, better than the other options right now but I am waiting for an MMO with action combat and decent everything else to go with it.
There are a lot of MMOs in development that will be making an appearance on console over the next few months and years. Blue Protocol and Throne and Liberty will have console beta tests next year. I have low expectations but will try them out. I got to test the alpha for Throne and Liberty after the combat revamp on PS5 and it was… alright. But it was early game, so we will see.
In the interim, I just play Division 2 and Fortnite Save the World as I wait for newer PvE games.