This review contains spoilers, click expand to view.
This game is probably so popular out of nostalgia. I'm a long time Zelda fan, have played a majority of the series ever since childhood, starting with the original, love this series more than any other video game series (along with Final Fantasy), but as I played Majora's Mask, I just kept waiting for it to get good, and it didn't.
I think this game relied too heavily on regurgitating content from Ocarina of Time. Character models, weapons and items, soundtrack, sound effects, so many things were exactly the same. It seems like they lazily slopped together something new from old content. Where the hell is Zelda? Isn't this the Legend of Zelda? She was shown in a flashback and I kept waiting to see her actually have a part in this plot, but she didn't. No explanation for why childhood link has ended up in "Termina", no longer in Hyrule, but all the same people he knew in Hyrule were there, some of them mortal enemies in Ocarina of Time, now just chums.
The time mechanic was the most terrible annoyance and seemed pointless. Most of the "scheduled" events were sidequests that you had a one in a million-chance of being at the right place at the right time to encounter without using a walkthrough. I'm shocked to know that the Song of Double Time wasn't in the original because if I had had to wait for time to pass over and over I'd have wasted such a huge chunk of my life playing this game I'd have probably given up after the first temple (oh wait, that is exactly what happened when I played it on N64 long ago). Though my biggest annoyance was that even after slowing the flow of time there were times I ran out of time JUST as I was nearing the end of a dungeon. It's bad enough you have to be timed trying to solve the dungeons, but it's a slap in the face that there's a freaking collect quest in each one for great fairies, some of which are practically impossible to find without a walkthrough. Some dungeons I had to make a choice whether to finish it and fight the boss or take the fairies to the fountain b/c I wouldn't have time to do both before the world ends. So I had to do one and then start the days over and go through the temple from scratch. Who the hell thought that would be fun? It's not fun. It's a waste of time and utterly annoying.
I think this game insults its players by making them repeat many tasks via the time mechanic, not just if you run out of time, but if you want to get alternate options on a quest, or if you have to go "correct" one of the four regions again by fighting its boss to start another quest in that area that is dependent on it being in its proper state.
Honestly, the countdown timer in the game didn't make me feel a sense of impending doom since there is no real end to it and you can just start over. All it did was make me aware that hours of my life were trickling away as I played this. I am all for the designers of Zelda taking liberty with a game that strays from the traditions, but I just didn't like this game, and I played it all the way to the pointless, lackluster finale where nothing made sense and it got surprisingly even more gaudy than it already was. I feel like this game is a window into someone's acid trip... Rather than it having the poignant dream-like feel of Link's Awakening or the dark delusion and gloom of Twilight Princess, it all just seemed so tacky and unguided, so random. Links screams and animation every time he put on a mask were gag-inducing.
There really wasn't much of a plot or any friends or emotional attachments for Link either, so storywise this game was really shallow. The only time I got a remotely emotional reaction was during an optional side quest about Anju and Kafei... and maybe for a split second over that Zora who dies on the beach, whose friends and girlfriend never find out he's dead... unsettlingly.
I didn't actually enjoy playing as the various species except maybe the Goron. The various controls and attacks seemed to make Link's set of equipment fairly useless and it didn't feel like a Zelda game much. Imagine playing Twilight Princess as a wolf for 3/4 of the game and how awful that would have made it. That's how I felt here. There were also many, many times where this game just had awful controls and physics, especially when controlling the alternate forms, and it would punish you with constantly having to redo or retry something to get it right when the problem isn't that the player isn't skilled. It's that the controls are clumsy and unresponsive and often do the opposite of what you tell them to.
The music in this game was mostly not memorable, and the new ocarina and instrument "songs" were terrible. Most sounded like random notes and not songs, unlike the very memorable tunes in Ocarina of Time.
I feel really disappointed and surprised at how bad this game is, so much that I'm struggling to feel this was a Zelda game and wondering how it earns its praises. It's gotta be nostalgia or people who love side-quest games.… Expand