|Yeah, I don't like being eyeballed either.|
Because, yes, you can have dungeons in this game but the dungeons need to be themed puzzles in and of themselves. The players need to pay attention to their surroundings and use it to their best advantage just as you need to set things up to their disadvantage. Why not throw some lava in the room? Underwater sections? Reverse the gravity? Do something different. Dare to be different. The players' creativity and imagination should always be engaged by the situations they encounter.
And yes, a lot of this advice works quite well for any fantasy-based campaign. It's fantasy, for goodness sake! Try to make it fantastical! The players should expect the unexpected. Have their assumptions proven wrong and proven right with equal abandon. Engaging with fantasy tropes is all well and good, but there's no need to make things derivative just because that's what the majority have done. The secret of fantasy, especially in roleplay more than anywhere else, is that there doesn't need to be any sacred rules while worldbuilding. Take full advantage of this fact in this sort of campaign. While there must be internal consistency, it doesn't have to be consistent with every other fantasy story you've experienced.
Anyway, a campaign based around Zelda: Ocarina of Time, or including elements of it, should appeal to Explorers as the situations themselves should be interesting and there should be rewards around every corner for those who care to look.
Investigators may find the mysteries themselves rather easy to solve but should find enough surprises in front of them to keep them interested.
Tacticians will enjoy figuring out how this new piece of magical equipment might be used to unlock the next section.
Action Heroes will love the excuse to hack and slash their way through the various dungeons to find their way to the big boss at the end.
Communicators will like the slightly off-kiltre personalities they encounter though may find the lack of opportunities to use social prowess and political insight to their advantage rather stifling.
If you want to read up on the TV Tropes you can find them here.