Okay, I finally got around to watching the conference.
Holy crap, I can't believe some people were complaining and not impressed by this. I think that my statement that Nintendo would dominate Sony and Microsoft has absolutely come true.
They showed so much footage of what the controller/console could do. The ability for the console to stream the content to the controller screen was enough alone to blow me away - but there were so many other ways that they could interact. Then they ran through all the promised third party games, and announced a Smash Bros for 3DS & Wii U...
Yeah, the Nintendo conference made this E3 not suck. I'm ready to buy this thing right now.
edit: That video looks great. I can think of so many great uses for the controller screen. It looks like the guy in the video used it as a heli-cam to check out the enemies location before moving in. Could also use it to navigate a robot bomb.