Red Dead Redemption
The "first" ending really gutted me. But then the real ending? Holy shit. Perfect in theme and execution. Maybe it was just me, but the whole idea of the futility of revenge and then making the actual revenge of a character you grew close to over the narrative feel empty? Holy Shit was that awesome