As someone who lacks natural talent for video games, I can say I have no problem with guides in Zelda for newer players. When I was still new to the series, and new to video games as a whole, I wouldn't have made it through my first few games without a guide book. In fact, I didn't make it through OoT when I first played it. The first Zelda I beat was WW and I had to use a guidebook. Now that I am used to the feel of the games, I don't need one anymore, but I understand the logic behind having one. There's a fine line between having difficulty figuring out a difficult puzzle and being clueless on what to do. Some players just need more help to get through the game and I don't see why an optional guide system would be a problem. It expands the game's audience.
However, I don't know how Super Guides would work in a Zelda game. I could see having an option where you choose just how many clues you want or possibly how cryptic you want the clues, but having the game play through a level? Then again, I don't know much about Super Guides, but from what I've heard about it, I don't think it's something that would be in a Zelda game.
(Just a note about the companions: Other than Navi, I don't feel like they're that helpful. Sure, they typically tell you where to go, some more than others, but when it comes to dungeons, they don't do much in the way of being a helpful guide.)