Not the best intro ever made, but Master of Magic
made an impact on me for some reason.
No idea why, but the "Old man" bit always stayed with me.
The Lands of Lore
intro stayed with me because of Patrick Stewart.
My favorite intro is probably a toss-up between Syndicate
, System Shock
Man there are a lot of good intro's.