When thinking of endings, I think of Portal. The ending itself wasn't all that imaginative, but you have to take the credits song into account and that is the icing on the cake.
I did enjoy the ending of CoD4, that was one hell of a rush.
I really can't see why Half Life scores that well...