I think the midna scene is the top of the list. But i two more that i want to mention:
1) in OoT when Saria give Link the her ocarina and then Link backs awaya and turns and runs after her heartfelt story....awwwww.
2) MM when tatl tells the story of how her tael and the skull kid became...