Being a masochist doesn't automatically mean suffering pain should be widely considered as fun
Shadowbringers was overall pretty good for the most part. I cannot recall any actual fight I would classify as frustrating or explicitly unfun, except maybe light rampant. but you could definitely see the escalation of things to being how they were in Endwalker.
Endwalker in particular is where things have gotten out of hand.
Of pandaemonium, P1-2S are great. 1s is a little boring though. 2S should be recognized as a gold standard of content.
3S was complete and utter dogshit raid design. Visual clutter and obnoxiously bright, unforgiving mechanics and the fight itself drug on way too long, but that's par for the course for a phoenix fight.
4S also kind of cringe, 1st half of 4S honestly sucks but second half is alright.
second tier was all abysmal dogshit, overly complicated garbage and obnoxious encounter design, I think only P6S had remotely entertaining mechanics
third tier was more of the same, I honestly skipped third tier and never did it when it was relevant because I was done at that point, and I knew from just watching videos and streams about it that my decision was right.
I have not done DSR or TOP, and have no desire to. I have a general disdain for ultimates because they go on too long so they are all more trials of attrition. (also the ultimate weapons are all awful glow vomit and unappealing but that's just me)
Dawntrail, at the very least so far, has been very good. the normal arcadion raids are already very fun and just hard enough I feel to satisfy everyone, I have high hopes for savage but to be completely honest I have no static and no desire to prog savage anymore.
The biggest problem with "hardcore players" in XIV is honestly the elitist mentality, and unfortunately this mentality is just enabled by almost everyone and the devs turn a blind eye. No one is willing to own up to their own mistakes, everyone wants CLEAR NOW and don't realize wiping is part of learning. The "upper echelons" of raiders in this game are filled with epeen strokers.