Well, I am not sure I have a favorite moment, but I would say it would be a combination (like nick_coolhaha) of figuring out all of the many puzzles, and the great feeling of finally solving them, especially the water temple.... I was in that place for sooooo long.