Majora's Mask is my least favourite 3D Zelda game by far, despite having the most interesting premise.
It's more awkward than it is challenging, the different characters you can become are Rare-level cheese, and the save system sucks.
I really hope it gets the remake treatment like OoT, though, because it has a lot of good ideas.