Indeed, Twilight Princess' ending is one of the most touching LoZ moments of all. It's a shame I can't remember everything from the other Zelda games I've played...
This next one isn't really a 'moment', but having Dampé (one of my favorite characters) out of the stage forever makes me sad...