For basic information about E3, please see Chiyo's Post.
Only watched about 30 mins of Nintendo's press conference before I had to go to dinner. Zelda didn't really impress me noteworthily. Not feeling the hype =/ I think part of that may be because we we're directly thrown into the gameplay demo, without a proper introduction/trailer for the game. It lacked the epicness of other Zelda announcements/demonstrations. The graphical style and gameplay does look nice, though. The graphics looks like that of TP but softer, with a more colourful touch. Looks a bit celshaded, really. Too bad about the technical problems that ocurred during the demonstration - interference as Miyamoto declared. He said that development will be finished by the end of the year (if I remember correctly), and that we'll get to play it next year. No dates, though. Oh yeah, and it's called The Legend of Zelda: Skyward Sword.
Edit: Oh kewl, I made a thread.