So if the recent Zelda U rumour is true, how would you feel about it? Over 100 mini-dungeons and 4 main dungeons.
I think it'd be good cos there will be something to do however I'd be worried there won't be many Majora's Mask-eqsue side quests or side quests in general.
Also I'd be hoping for those 4 main dungeons to be M A S S I V E.
It depends on how they execute it.
If it's like those random caves in Twilight Princess where you have to bomb through 20 walls in a row just to get a few Rupees and maybe a Heart Piece (or a stamp in the HD version), then I won't like it.
If they put something more meaningful in some of them (I'm OK with SOME of them containing Heart Pieces but I don't want that to be all there is to it), then it could be great. Like, each one has their own unique artifact and you can take them to some archaeologist character who examines it and it reveals some kind of lore about the world, and you get something cool for every 10 you collect, or for completing a set, like an upgrade to a weapon or something. They could also make it like the secret dungeon in Link's Awakening DX, where you find something like the tunic upgrades from that game, or upgrades to your items. Also, if the game has a crafting system (and I think it will), then some really rare crafting materials could be found in these mini-dungeons.
As for the four main dungeons, I want them to be two or three times as long a typical Zelda dungeon. I want them to feel like true trials of endurance and wit. They could even make it so that you can't actually beat them without having certain items or resources, so rather than it being a case of "this is the boomerang dungeon, now this is the hookshot dungeon, etc", you need to take initiative when going in blind and just gather as many tools as you can in the world and from the mini-dungeons, in hopes that you have what you need to explore it fully. And of course there could be a way to warp in and out of the big dungeons if you hit a dead end, similar to Oocoo in Twilight Princess.
I essentially think this idea has the potential to embody a real sense of adventure, but it depends on how they go about it.