I've been playing FFXIV since HW and I'm pretty baffled by these weird outspoken issues to Endwalker. This MMO has never been in better shape, the main MSQ story in 6.0 was a masterclass in storytelling. Not a single dungeon missed (and was the first expansion to do this)... There is a TON to do in this game... I personally loved the Alliance raid, which was beautiful.
Haven't run out of engaging stuff to do in EW. I don't see any issues.
Personally, I think Dawntrail has a MASSIVE job cut out for it to get near the level of these last two expansion... I have no idea how they will pull it off. I just hope they can come somewhat close.
