Totally agreed. Nothing against them, but I personally *hate* open-world games, almost universally so. I much prefer a more curated experience.
I like the idea of having a *bit* of flexibility -- like maybe you can tackle certain "groups" of dungeons in any order, so you still get major story beats in the correct order, but encouraging real exploration (with meaningful rewards).
My perfect Zelda is ideally something like Dragons Dogma Dark Arisen, Kingdoms of Amalur or Severance Blade of Darkness. Where the game is linear and curated but it's a semi open world.
Main draw of Zelda for me has always been Dungeons, Quests, Puzzles and acquiring meaningful gear. And making the Master Sword/Champion Weapons break is just immersion breaking. As those weapons are supposed to be the best of the best. When in reality it boils down to farming Lynel weapons.
There needs to be some freedom but not too much.
I'd really like OoT/TP but with postgame dungeons beyond the main quest that really test all of your abilities and what you've learned in the game. And you can only access these dungeons near the end. Zelda needs some postgame like the Cave of Ordeals from TP. Something to keep you playing the game but in such a fashion that is engaging and fun to keep doing so.
If they could make the game with some great atmosphere on a Tomb Raider 1 level I'd be stoked. I think of all the "dungeons" in TotK I only really enjoyed getting to the Wind Temple and the Dungeon with Riju where it's very Indiana Jones.
Though to be honest with all newer games giving focus to character creators it might be best to introduce Link and Linkle options or throw a monkey wrench into things and allow the player to choose their own Hero as a Hylian, Goron, Zora, Gerudo, Twili. All with their own pros and cons to change the way you play or interact.
Just some form of replayability is all.
I do agree with some others that I too would also like some Underwater exploration too. Especially after per say getting Zora themed gear. I really loved TP with Zora Armor and Iron Boots. The Water Dungeon was cool with that stuff.