Disaster: Day of Crisis

I go with Onimusha 2.

1. Final Fantasy VIII
2. Killzone 2
3. MechWarrior 3

FF VIII intro is the best IMHO.

I second the Half Life train ride introduction, it is simply put pure genius and one of the pinnacles of video game story telling IMO. So casual, perfectly out-of-your-face and ordinary, and still it manages to introduce you to the Black Mesa, introduce your character and really set you up for the game. No CGI video can achieve the same.

I was a big fan of Mass Effect's intro. It felt just like starting a movie, really got me amped about the game. I would sit through the whole intro on every play-through.

No more heroes without a fucking doubt!

Kingdom Hearts.

Okami. No, it was not too long.

Mechwarrior 4:

Mechwarrior 4 : Mercenaries

StarLancer

Neverwinter Nights

Icewind Dale