A few moments where I really was hyped:
Xenoblade Chronicles X's announcement. If it has the effect the original Xenoblade had (in the sense of popularity with people who likes JRPGs), then, I think it'll help the WiiU. Plus, it's a cool game. The only thing that could be considered "sad" is that maybe the game will be 720p @30fps instead of the 1080p @60fps we have on the WiiU. Sad but well, given how polished the game is, we can do a few sacrifices, I suppose. Especially considering how they technically pushed the WiiU. Plus, it's Monolith Soft's first HD game, so, we can't blame them either.
Super Smash Bros 4. That is all I can say. There was a massive hype overload about the game, and I was in. That hype couldn't be described by any mean.
Persona Q's announcement. Finally a Persona game that isn't Sony-exclusive. I had the PSP, but I wasn't and I won't plan on getting a Vita, so, this made me happy. More, it features the characters of Persona 3 and 4, meaning that I would just have to get used to the P4 characters. (Plus, now that I have it, I can affirm it: it's a great game)