Not particularly.
I've played and watched playthroughs of plenty of story games, some of which I'd genuinely call masterpieces of storytelling, and I still enjoyed the majority of the Endwalker MSQ. Would I call IT a masterpiece? No. It had it's flaws, imo the worst being odd pacing, uninteresting villains early on (specifically Zenos and Fandaniel for a fair chunk of it), and frankly a too long list of characters - too long to do most of them justice. But I still enjoyed the story overall, and I still actually like almost all of the Scions.
...and the one I don't like is Krile. So.