Let this become the thread to post awesome-looking game trailers.
IMO http://www.gametrailers.com/ is the best site to find these.
I'll start off with a few. First off is the incredible E3 2006 15-minute long trailer for Metal Gear Solid 4: Guns of the Patriots.
It can be found in normal and HD versions here (though I'm afraid you'll have to supply your own towels to clean up your drool):
http://www.gametrailers.com/gamepage.php?fs=1&id=1743
Next, here's one that looks very fascinating indeed, called Heavy Rain. I have no idea what the game itself will be like, but it's from the guys who did the pretty good (if slightly disappoinging and overly minigame-ridden) adventure game Indigo Propechy. I really love this trailer, though, because here we have a female character who isn't really attractive, and puts on a performance--here, finally, it seems we have a game focusing on characters and emotion. Now let's hope there are less Simon Says type minigames this time.
http://www.gametrailers.com/gamepage.php?fs=1&id=2717
Next we have...ZOMBIES!! This game, Dead Rising, looks pretty disguisting, but awesome. Best zombie killing simulator yet?
http://www.gametrailers.com/gamepage.php?fs=1&id=1781
This one's Bullet Witch...could be allright:
http://www.gametrailers.com/gamepage.php?id=2485
Next up is Eight Days, a very slick-looking new action game...pretty amazing graphics and animation:
http://www.gametrailers.com/gamepage.php?fs=1&id=2644
Here's the E3 2006 trailer for the (episodic) new Sam and Max game series...WHY must they be episodic?
http://www.gametrailers.com/gamepage.php?fs=1&id=2744
Feel free to post any ones that catch your eye.