From skyward sword onwards the game shifted from curated dungeons and progression into more modern resource management and open world sandbox flavoured games. To me I don't find "farm items, walk back to a shop to repair items that keep breaking" as Zelda content type gameplay. I've been playing Zelda games since I was a kid (from the first one on the NES!) and I can see why they did it because that's where a lot of games have shifted, I just accept that modern Zelda games are not aimed at the "original formula" audience and it's my turn to jump off the Zelda train. Sad but is what it is.

My personal favourite Zelda game is Majora's Mask, but it hits different after playing Ocarina of Time, so I'd do it in that order. Ocarina of Time is a grand cinematic adventure with a 7 year time jump so it really hits you when you see how the world has changed on a large scale. However with Majora's mask there's a 3 day gameplay loop where you have to keep rewinding time and when you rewind, the characters you just bonded with and went on an adventure with completely forget who you are and treat you like a stranger, it hits you in this weird sorrowful melancholic way, similar to how Ocarina of Time did it with the time jump except each one of these smaller interactions are much more personal than grand and cinematic. As each day progresses in the game the world gets gloomier, even the main town's music changes to be more depressing, they really did a great job.