Is the 6.0 patch content worth playing though?
No.
The current MSQ storyline has a cool premise: work for the king of Thavnair and explore the Void, but it's badly presented. You still have to put up with hours and hours of visual novel cutscenes with formulaic scene pacing and predictable dialogue. You still have to put up with the Scions. You don't get to explore new areas of Thavnair. You only get to visit the Void in 15 minute long corridor dungeons, not as full blown questing zones. There is no tension as 4 out of the 5 antagonists are killed off almost as quickly as they are introduced and inflict zero damage to Thavnair or to the Scions. The defeat of the fifth and final antagonist and the success of the mission is a foregone conclusion so there isn't any motivation to turn the page and find out what happens next. The heroes will probably save the Void while their at it too. Also, you revisit Garlemald and it completely breezes over interesting story materials such as their Reaper lore or Garlemald's reconstruction.
The 8-man raid story is... okay. Not really exciting but not awful either. Once again, you have the intriguing premise of exploring a wizard prison, but then you never really get to thoroughly explore it. You just get teleported from boss fight to boss fight. Can't remember any of the bosses being special.
The 24-man alliance raid story is pretty awful. You have to put up with G'raha Tia and an uwu Roegadyn girl. More gratuitous wank as the gods pat you on the back. Only notable thing about is that the first raid had a boss arena that wasn't a square or a circle (the fight on top of the statue's stone hand with the moving finger).
I think there is a questline with Tataru where you go around meeting up with past characters again, but I haven't done it. Sounds like more overly saacharine, mastrubatory crap.
There is no difficult Eureka/Bozja zone that you spend a lot of time in and forces you to make friends. No difficult raid like BA or Castrum or DR. We now have wellfare relic weapons that you get from doing more of that gag comedy storyline about the detective and spending 1,500 tomestones.
They added a new 5v5 PvP arena (same gamemode of push the crystal), but honestly PvP in FFXIV isn't very enjoyable. The time to kill is ridiculously short. You get bursted down faster than you do in WoW PvP or GW2 5v5 matches. You can't mount up in the arenas and there is only one objective, so there is hardly any downtime and strategic decision making like in other MMOs where you are travelling to a location or guarding an objective. Combined with the sliding and the clunky engine and input delay, it just feels bad.
They added a new Gold Saucer jumping puzzle but it feels like a decline design wise.
Overall wouldn't recommend. If you want to play an MMO then I'd advise checking out GW2 or WoW atm, but honestly the genre as a whole is in an awful state and there isn't any hope for the future. All three games are in managed decline. I had hope that the Runeterra MMO would save the genre, but Greg Street has left Riot so there goes that. Currently playing WoW atm, killing puny alliance in RBGs and in war mode. New content patch comes out next week. Story is shit but at least we're getting a new zone next week and the combat and character building is fun. Only reason I'm still subscribed to FF14 is because I don't want to lose my house but I'm gradually caring less and less about that. My friends who were playing FF14 since ARR have quit, some going back to WoW but most exiting the MMO genre entirely. 7.0 is going to make or break my interest in FF14.