Actually, I have to agree with you. That moment is by far my favourite of the series.

Another good moment was when

Midna broke the mirror at the end of Twilight Princess

(not sure if that's really spoiler-worthy, but may as well put it in spoiler captions)