I think it's apt to make a comparison of the openings of Ocarina of Time and Twilight Princess.
Ocarina of Time's opening is shorter, and most of the tutorial stuff is optional. A lot of the length in Twilight Princess opening comes from cutscenes that are wayyy too long, and that god damned fishing minigame that isn't even a little bit fun. Oh, and then there's the goat herding, which you have to do twice.
Zelda games aren't that complicated. Tutorials aren't really needed at all, and if they insist on including them, then they ought to keep them short.
There's also the issue of tone. How does Ocarina of Time begin? A fairy flies into your room and wakes you up shouting "SHIT IS GETTING REAL! GET YOUR ASS UP OUTTA BED! THERE'S BAD STUFF GOING ON! GO GET A SWORD! GO GET A SHIELD! NOW GET YOUR ASS INTO THE DUNGEON!"
The opening of OoT isn't perfect, but there's urgency there. Something is happening. There's adventure to be had.
In contrast, the opening of Twilight Princess includes:
1. Performing routine horse care.
2. Going to your day job.
3. Doing odd-jobs around town.
4. Being told that you're being entrusted with the ever-so exciting task of...a delivery job.

I've got at least 2 hours of gameplay time under my belt at this point, and the game has yet to pick up any steam. During the brief intermissions between cutscenes, I've yet to actually be allowed to swing a sword. There was some dumb thing about a bunch of kids I didn't care about getting captured, and I kept thinking "Okay, is this where I get to start playing the game? To save the kids?" But no, then they turn you into a dog. Which, whatever. I think it's dumb, but I'm not going to shit on the idea. It was an odd choice, an experimentation, kudos to them for trying something. Unfortunately, they fucked it up. The jingle-jangle of that god-damned chain around your leg is ear-bleedingly maddening. Midna is somehow even more annoying than Navi ever was. And blah blah blah, boring story boring story, something about light spirits, then I got to fight a few guys as a dog. The introduction cutscenes for the enemies took longer than the actual fight against those enemies did. Bleeeeeeeeeeeeerg.
I'm really hoping I can eventually get SOMETHING out of this game. (Well, something other than the self-important feeling I get from hating something as hard as I hate Twilight Princess so far).