For endings in games Final Fantasy IX and X both had great ones to me that gave closure.
Metal Gear Solid 3's was definitely emotional.
I remember liking Halo 1 or 2's ending, but I can't even remember it or which one it was.
Metal Gear Solid 2 had a WTF ending.