This defined my youth and was the very first game of whose intro I took particular note.
Sorry but any answer other than Half-life is just wrong. That intro was just nuts that you basically see all the areas you visit later during the game.
Honorable mention: Super Mario 64. If you grew up with Commodore 64 and later NES and Super NES, you couldn't believe what you are seeing.