A couple stand out to me. One from The Longest Journey where you go outside the Border House for the first time and the camera pans up so that you can see the futuristic skyline with the flying cars zooming by. When I saw that for the first time I knew that this game was going to be special.
Also I love in Grim Fandango the transition from Year 1 to Year 2.