Thinking back, the 5+ hour stream was really the best way to unveil this game. Before the unveiling I was sceptical, because I doubted they could make a stream of one game interesting for that long, but turns out that was exactly what the game needed... without even touching story elements. I was not prepared for the scope of this game, I don't think anyone was.
It worked to an extent that just playing the trailer for friends doesn't really work to show this game off. You'd almost need a treehouse compilation to do so.
Before E3 we had this 'your worst fears' thread and mine was Zelda just being 'another Zelda'. They did pretty much everything opposite of that, I can't tell how excited I am for the new direction they've taken here. Just doing away with 20 useless rupee chests as an exploration reward is already exciting for me. It's pretty standard stuff in other games, but I'm glad they chose to have more rpg elements this time around.
All I'm hoping for now is an online element where you can compare progress/discoveries with friends/gaffers etc. If I got 100% in this game, I'd want to show it off