Some of the most touching moments for me (all from TP) are:
When Link first turns into a wolf, that part was just really exciting for me
When Midna and Link are About to enter the realm of Twilight, and Link figures out what Midna has been keeping from him.
And the end, I haven't seen...