Adventure of Link is a great game.
The Water Temple is neither an excessively difficult dungeon nor the hardest dungeon in the game. Additionally, it's a top tier dungeon all around.
Tri Force Heroes is really fun and the cheesy story really doesn't matter.
Skyward Sword's motion controls are fine.
Breath of the Wild is heavily flawed and far from the definitive Zelda experience; not only is it not the best Zelda game, I would argue it's not even top 3.
Ocarina of Time does not hold up as much as the highest rated game ever should.
Exploring the Great Sea is great.
City in the Sky is the single worst dungeon in the entire franchise.
I'm sure there are more I have, these are just the first ones I could think of.
I would say most of these still hold up, but I'd like to add a couple more:
- BotW2 should absolutely not reuse BotW's overworld.
- Majora's Mask is the greatest Zelda game, greatest Nintendo game, and perhaps greatest video game in general.
- Button controls for SSHD were a bad idea (came up with this one after trying them).
- The Triforce Shard Hunt is not that bad
- Tingle is actually a hilarious character who I'm glad gets to be recurring.
- Age of Calamity's story is actually pretty good.
- Most of the one-off villains are far more compelling than Ganondorf has been in any of his appearances bar TWW.
- ALBW is better than ALttP and the rental system is fine.
- Anyone who says TP has item usage problems is just wrong.
- If BotW becomes Zelda's "future" then I may not stick around for the ride.