controversial opinion, but zelda ocarina of time and majora's mask to some extent too.
it's a slog to get the ball rolling. about the first quarter of the game is so slow and tedious that i always just try to speedrun through it until you open the temple of time. then the game really begins.
i've played less mm, but it starts to get good around the time you get the goron mask sorely because you can at least move faster. it helps that most of the things you can do are optional, so you can skip some of the slow and boring stuff.
and this comes from someone that likes and actually enjoys the water temple.
in later zelda games, say twilight princess, the start is a little better because the tutorial dungeons are more enjoyable.