I agree with Resident Evil 2's intro...still awesome to this day...I love how RE Outbreak tries to re-create that moment.

Another favorite of mine is the opening intro to Final Fantasy Tactics on PSX...that was a nice intro...