The hype for me is definitely dead now.
They did say that Zelda U wouldn't be at E3 but then they said it'd just be for 2015 titles and focus on WiiU titles... both turned out to be false so there was a chance we'd still see something of Zelda U but alas...
It wasn't E3 that killed my hype though, it was Reggie's recent press release which has to be the biggest pile of bull**** that has ever come out of that man's mouth. To summerise he said that Nintendo as a company didn't like to show off titles that are too far away and instead wanted to focus on titles releasing in the holiday season and early next year...
There's a few things wrong with this statement; firstly, Yoshi's Woolly World, Mario Kart, Bayonetta 2 and other Wii U and 3DS titles have been shown off at E3s in the past that have taken two years plus to actually arrive. In fact, I'm pretty sure that screenshots for Woolly World surfaced not long after the WiiU's actual release so that game has been coming for almost 3 years and its still not here...
Secondly he said this year's holiday season and EARLY next year... okay, so early next year means I'll be playing Fire Emblem Fates and Fire Emblem x Shin Megami Tensei, lovely, that's fine. But not Zelda U, a game that was shown last year not only with a reveal at E3 but also a five minute gameplay video at a following event the same year, a game that was supposed to release this year and be playable at E3... If people didn't know any better when watching this year's E3 they'd probably believe that Zelda U didn't actually exist.
So for a game that has had almost 5 years worth of production already, that was going to be playable this year at E3, to now not being shown at all and releasing not early next year but god knows when (perhaps after the next E3 when they reveal the next home console...that the game is looking more and more likely to appear on even though i don't want to believe it).
So yeah, Zelda U has fallen so far down on the release schedule that its now ambiguous if its going to release on its planned console at all, or if there's going to be another version alongside of it with new features (or features that were ripped out of the U version to be exclusive on the NX) that I no longer have the hype for the game, in fact I no longer care about the game at all.
I haven't truly loved a Zelda game since 2003, and by the time Zelda U releases I'm probably going to be so jaded (and pissed off if two versions of it exist to flog a new already doomed [because its Nintendo] console) that despite the game's best intentions and quality I'm going to have negative opinions about it, because after so long, whatever it gives me won't be enough to justify the excruciating wait and the brass-necked white lies that Nintendo are now covering themselves and its production with.