So we have all played those games with a truly unforgettable intro, in one way or another (be it a game screen before you press the start button *looks at Zelda OOT*) and they stick with you, even long after the game itself has faded from your (by your I mean mine, my memory is terrible lol) memory.
Here I would ask you what is your most memorable intro to a game, you don't have to limit yourself to one.
For me one of the most memorable game intros has to be Shadow of the Colossus:
You, a lone man, traverses a vast beautiful land that is hauntingly devoid of life, as you make your way to a beautiful old temple... one of the best intros I have seen by far.
I could name several others but I would rather leave them till later and see what everyone else has to say.