Odd no one mentioned Mass Effect 3 yet, since that ending got some really negative press (rightfully so).

FFXIII-2 was also a really good answer, though the whole plot of that game was on thin ice to begin with. The ending just plunged right through the ice and then the stupid 'secret ending' set off a nuclear bomb in the freezing water.