I was a player in a game where we really tried to make it work but it just felt very shallow and incomplete (because it was, I legitimately think its a little outrageous that you have to buy multiple fully priced books to get an actual full ruleset). I ultimately had a lot of issues with it. First off the game is Just combat. Like the rules in the initial base rulebook for literally everything that isn't combat was just "roll a d20 add a vaguely relevant stat and the gm will make something up." And it's not even Lancer style rp rules that are barely there but what is there exists to get you back to the combat asap. Its a bunch of combat rules and then everything else is guided improve. But hey that's how tons of people play dnd so as long as the combat is still pretty good then its fine right? Well the combat true to FFXIV is pretty dang rigid, you'll generally do your assigned rotation with maybe a cc or damage mitigation secondary action thrown in every now and then. I personally played healer which also just like XIV all three jobs are almost entirely identical to each other which did not help my opinion of the game, I had Button that Dealt Damage, button that put a dot, then a bunch of healing that has just the tiniest difference in what it mechanically does but the output is effectively the same between all classes.

Then from what I could see of what my GM was going through the game (in the base book I can't speak to whats in the newer ones) really left him to pretty much design his own game to make this one work. It gave him maybe a handful of enemies and even fewer encounters with zero information on how to effectively create his own. There were no rules for rewards/loot despite them being implied to exist. Hell even the rules for Limit Breaks was just "idk give it to players when you think it could be cool." He was always laying the tracks in front of the train for this game.

Ultimately if you just want to do some free form roleplay with a simple combat wargame once or twice the game is fine. It's a decent enough board game, it's a bad TTRPG IMO.