I finished Endwalker's MSQ a couple hours ago. Wrote an indepth post on it on another forum. I give it a 5/10. Rushed, convoluted story that flip flopped on what it wanted to be, was awkwardly paced, and botched the payoff. The story was also very cynical (despite the repetitive speeches and empty platitudes about hope and such). I found the rolequests to be much more enjoyable.
I will check out the next expansion, but if the future of FFXIV's storytelling is going to be more Kingdom Hearts sob stories from Ishikawa, I'm out.