Didn't get the time to watch the presentations as they happened, this year (and cba to after - I've just read reports), but here's my impressions...
Hardware
The U hardware details still seem patchy despite all their pressers etc., but apparently it'll now support 2 tablets - but will drop from 60 to 30 fps if you do so. Meh. As I've said all along, if it only supports one tablet and other players without the tablet aren't at a disadvantage then the tablet's an unnecessary gimmick. If it supports more than one it's expensive. Either way it's screwed.
And the battery doesn't sound too clever to me, with 4 hours play but 3 hours to recharge (which can be done simultaneously, but would be similar to playing with a wired controller. I'd hoped those days were long gone).
No news from MS or Sony on their next consoles - no real surprise there, though we were all secretly hoping for something from them. (Sony seem to be dropping hints that their next console will be rather costly, though - so there's a good chance we're looking at similar situation to the current gen, with the Sony being premium, the MS cutting a few corners and being a bit cheaper, and the Ninty being the wacky but essentially crap budget option.)
Tablet/phone integration into console gaming and media has been on the cards for a while, and tbh I'm not terribly excited by the prospect. It looks to me like the U, where you're getting a normal game with a few gimmicky things tacked on. Switching your attention from the tv to a mobile device means you're not giving the game your full attention and it's less immersive. It's only advantage over the U would be that the tablets are more clearly an optional extra device and are a device you probably already have and can use for other stuff more realistically than you might the U controller.
There are a few exceptions, of course. Playing an Aliens game (Colonial Marines is still looking awesome) with the action on the tv but a motion scanner in your hands or tacked onto a light-gun would be all kinds of awesome. Imagine playing the game, being properly spooked as you know the xenomorphs are nearby, then hearing the familiar beep coming from the motion scanner - you're left in a position where you want to tear your eyes away from the tv but daren't. "Tacked onto a lightgun" could also be pretty fantastic as a scope on a rifle.
On the whole, though, I see separate screens as a pointless alternative to just pressing a button to make something happen onscreen instead.
Software
I'll skip past the stuff we already knew about (Tomb Raider's looking great, but has QTE's - which I detest, Sim City's looking good, Halo/Gears/COD all look good but predictable...), and focus on the few new bits.
Nintendo games pretty much all looked uninspiring. On the U there's lots of party/mini games, lots of Mario, lots of yawns. The zombie game looks okay, but in amongst all the mediocrity that makes it stand out. Lego City looks good, but not groundbreaking. As seems to be the case with a lot of U games, it seems they make a game then add some gimmicky shite to make the controller tablet look useful, but it's clearly tatt added on. A prime example was demo'd with Arkham City.
It all seems very quiet on the 3DS front.
PS1 games (including FF) coming to Vita is great news, and should boost sales significantly - though I'm not tempted myself. I've a hankering to play FF7 and 8 again, but I want HD remakes on my plasma telly rather than ports to a handheld.
Watch Dogs looks absolutely beautiful and has an intriguing premise - nice surprise that one. Beyond, too, looks beautiful (though I'd been hoping for something sci-fi after the "Kara" demo a month or two back).
And then of course there's any number of dance games. Oh joy. :|
