Have to go other here, you just didn't mention Half Life in there did you?
I'm gonna say the best ending in recent history was to ME2, just awesome how it was done. And while Half Life hasn't exactly been finished yet (Valve needs to wake up ._.), it still deserves to be in this category. Come on :|