Now that the E3 is over I guess I'll post this.
Without being exhaustive, games to look forward to:
The Last of Us
Beyond
Resident Evil 6
Castlevania - Lords of Shadow 2
Tomb Raider (looks so very Uncharted)
Watch Dogs (it surprised me to see no mention to Thief 4, that's what Eidos Montreal was supposed to be doing..)
The E3 this year was quite disappointing for me, there was absolutely no surprise. Even the few things that could have been considered a surprise were leaked hours before the conferences.. At least Sony is trying to offer new IPs to expand their gaming catalogue.
The worst of the show, all the Kinect crap. It's depressing to see licenses wasted in games like Avengers - Battle for Earth