I'll give you Last of Us, Red Dead, ME2, and Portal...but FFX, and BS:I[footnote]I haven't player HL2 or Bastion so I can't weigh in on them[/footnote]
FFX's ending was terrible because its supposed protagonist was terrible. Honestly I was happy that the annoying little dick-nugget was going to fade away forever. Despite Tidus' repeated insistence that "This is my story!", as Spoony correctly points out: it's Yuna's story. Tidus is, if anything, a side-character whose story arc revolves around his unresolved daddy issues. His arc ends cleanly enough, but his story has little to nothing to do with the actual story: that being Spira is under the control of a cult of pedophile zombies that have the world worshiping a false god.
As for BS:I, that ending isn't nearly as good as it's hyped up to be...considering the fact that the end goal of the ending - a permanent erasure of Comstock from all possible timelines - isn't possible. I'll give them an A for effort in making a mind-bender of a story, but unfortunately the very fact that they're working with the multiverse theory means that you can literally just make up plot-holes and they become valid. But to focus on one specifically, let's look at the tail end of the ending. We're told that with every choice, a new universe branches off in which the opposite choice was made. That's what the story is based around: Booker going to the baptism and if he says "screw this" and walks away he keeps on being Booker while if he accepts it and gets baptized he goes on to become Comstock.
Well what about the choice to sacrifice himself at the end before the baptism even occurs? If Booker dies before the baptism, then indeed there'd be no chance for Comstock ever coming to be. However just as there was a choice to get baptized or not, so too was there a choice made to accept the sacrifice or not. The Booker we play as lets himself get drown...alright, what about the Booker who said "Screw that, I don't want to die"?