I never actually cried, but I came pretty close when Zelda sealed herself away. Her saying "I'm still your Zelda." and Link's expression... pretty emotional. I'm very surprised I wasn't crying a river, but I was sad when the scene was over, thinking about her sleeping for thousands of years.
I believe the scene at the end of the Earth Temple was very heart tugging.