This, I agree so much with this.
I refer to the poisoning of the Sultana as FFXIV trying to do "The Red Wedding" in a very negative connotation.
I sincerely could not take a single moment in that cutscene serious because by that point, we were literary already a Godslayer yet here was this twerp acting like he was a genuine threat.
And now... There's no more tension in the story. We are, a God, by all intents and purpose.
If you ask me the best ending for Endwalker is one where we died in the final battle and faded into legend.
But that'd mean an end to the adventure. Great for a book, or movie. Bad for a game aiming to keep players playing.
The cost of that however is, the removal of all tension.
There was a moment in Gunblade storyarc where, just for a split second, my mind went "What if this is the end?". I liked that thought.
So I agree with you fully.