Majora's Mask wasn't just sad, it was downright depressing. The ending where Kafai and Anju are killed by the moon is a real downer.
I found Twilight Princess' ending much sadder, and not in a depressing way. The idea of losing a friend forever has always been one of my biggest fears, so...