While there are worse examples which have already been mentioned in this thread, Chrono Cross definitely comes to mind. The game had a decent buildup, a fairly challenging second-to-last boss (which could have very well been the last boss)...
Honestly, that just kinda made me go...why? It had virtually nothing to do with the plot, and on top of that, it was an INCREDIBLY easy boss. After I beat the game and started a New Game+, I managed to go back and beat him
using Serge alone. It's pretty sad that you can defeat what should be the most difficult enemy in the game with a single character...hell, they might as well have just forced you to only use Serge in the battle by default. And while the "real" ending at least somewhat wrapped everything up, it still felt like a letdown.
Oh, and actually going back to the topic creator's point about FFX, wasn't the auto-life thing because of the Faith? At some point earlier in the game, one of them tells you that when you finally do face Yu Yevon that they would be helping you, and I think Yuna even mentions that she wondered what he meant after that, so I assumed they were responsible for the whole invulnerability thing.
Jam it back in, in the dark.