I'm suprised so few have mentioned the Silent Hill 4 E3 trailer. Sure, the game was disappointing, but that was one of the finest game trailers ever produced. It was almost TOO good, as it managed to give meaning to things that would actually have none in the game.
The one that starts with Mary talking about being in SH while James is rowing that boat is awesome. The music is what really carries it as you said. I still think Yamaoka is the best composer in the industry today.