From a gaming point of view, there wasn't much here to excite me or get me out of my seat. The Halo footage was great, visually stunning and fresh. Gears of War looked like Gears of War, care nothing for Dance Central 3 or Usher (seriously MS, no one that tunes into these things cares about showy popstars), Splinter Cell Blacklist looked good, quite excited by that. Another Forza, fair enough. Don't care much for Resident Evil, but it looked nice too. Tomb Raider looked excellent. I wish MS didn't rely on another end of show Call of Duty exclusivity reveal again, it's getting stale MS.
In terms of all the services and apps coming to the Xbox, for me it was a long list of things that I know I'm not going to use. The SmartGlass stuff is neat, but how many publishers/directors etc are going to care enough to create extra content for a minority of people that will use it. All the different sports that will make its way onto it as well matter nothing to me because I live in the UK and care nothing for any of those sports plus they wouldn't be released over here anyway. Internet Explorer for Xbox, really? *sigh*
Get the feeling that they are really pushing this whole "use the Xbox for everything" tactic, but really, I don't care. Just more good games please!