Maybe I'm just strange but, I found the saddest Zelda scene also one of the most ironic ones. It's the scene in Majora's Mask where you go to the ranch house on the third day and everyone is crying and paranoid about the moon falling.
But, when you talk to Anju, she says "I waited for...