When I was younger, Pokémon Mystery Dungeon: Explorers of Time. To this day, it's the only game ending to make me cry. In more recent times, Fire Emblem Awakening, the good(?) ending, especially when you have a large roster of characters, and Halo 4.