The first videogame intro i ever saw that managed to give me goosebumps, its from 1996 and probably the first time I saw CGI characters move in a natural and fluent way:
This is probably my all time favorite opening in a videogame, this is from 2004 when CGI models and animation had improved quite abit:








