Best intro cutscene? FF8, no contest.
But I do believe this topic is about best intro level, in which case FF8 is not worth mentioning.
FF7 is a good one, so is KH2. And Mario Galaxy, actually. When you land on that first flowery sphere with the Gateway music and run around it for the first time it's like a revelation.