I love Majora's Mask. It's unironically genius, particularly for an N64 game. Not... fun to play, admittedly.
The worldbuilding, storytelling, atmosphere, psychology, writing and (partly) soundtrack are incredibly good, though, and makes MM one of my favorite games that I never really feel like playing. I don't think it's all that good as a Zelda game, but it's more than good enough to deliver the awesome parts.
I'll never not cry like a little bitch about the Anju/Kafei story - love corrupted by random shit luck and greed, turned into confusion, doubt, loss and insecurity. If you follow the quest all the way to the end and manage to pull it all together, they're still stoically accepting their death - as long as they get to be together and are no longer worried they've been stood up or won't be accepted by their spouse.
The rest of the game is basically more of that, fixing sometimes heartbreaking problems caused by the mask - one at a time, several at a time, dealing with setbacks and resets. Every plotline you resolve does revert back to the miserable start, but you're also left with something "lasting" for each one, until you finally clear the game.
The denialism and eventual panic of the townspeople is really well done, the Clock Town music taking different forms depending on the day, where the third day is explicitly dark and ominous. People are panicking, going about their business as usual, taking refuge, worrying about unsettled scores, blustering and arguing...
It's a bit of a trippy experience wrapped in not-always-riveting gameplay, but the parts that work work extremely well, and if you're in the right frame of mind the game can get pretty philosophical.