Well, I might as well sum up my feelings on E3. I'll start by saying that Sony dominated this year. Plain and simple. Microsoft a "meh" second, and Nintendo in miserable last.

Sony:
After watching their press conference (the only one I've watched; I worked all during E3), I kinda want to get a PS3 :P I was already starting to yearn for it, but man, after I saw things like MAG, AC2 (which I could get on the 360, but still...), and Uncharted 2, I really want it! It's nice to see that Sony isn't completely bombing this gen, as I had begun to fear a few months back. Things that stuck out to me in their conference were:
MAG
AC2
Uncharted 2
FFXIII
ModNation Racers (actually looked fun :o)
and even GoW3 looked awesome, though I wasn't much of a fan of the first GoW

Microsoft:
I currently own a 360, so I'm already aware of what I'm looking forward to. Though, they did show some pretty cool stuff I wasn't expecting, like Left 4 Dead 2 (which is coming out exactly 1 year after the first L4D oddly enough). I haven't played the first L4D, but I've already ordered it online and will be playing it in a week or so. Looks good. Otherwise, most of what I want in the future of 360 games already had been announced (or released loads of info on), like BioShock 2, RB Beatles, AC2, Halo 3: ODST, etc. Here's what I'm looking forward to for the 360:
BioShock 2
RB The Beatles
AC2
Halo 3: ODST
L4D2
Modern Warfare 2
FFXIII

Nintendo:
Well, technically I also own a Wii (it's really my entire family's console) but I never play it. I have only played a handful of SSBB, and nothing more :P So I'm not too psyched about theirs (don't think anyone was lol). Though, I will say my desire to get a DS is also on the rise. Mostly because of The Castlevania games, but also for Golden Sun DS. I've never played the GBA ones, but I really liked what I saw of GS1, so it's only natural I would be attracted to GSDS. Things that I'm interested in for the Nintendo consoles are:
New Super Mario Bros.
FFCC: Crystal Bearers
KH: 358/2
Mario & Luigi: Bowser's Inside Story

Things that were lame:
(MS): Project Natal; Tony Hawk's Ride; social networking/XBL stuff
(SONY): Motion controls; FFXIV Online
(NIN): Women's Murder Club (WTF?); Wii Vitality Sensor