For me:
The most touching for me is a scene in Majora's Mask:
When you complete the Reuniting the Lovers quest... Anju and little Kafei finally are together, but the moon is about to fall. They tell Link to go find shelter, that they'll be okay because they're ready to "face the dawn...