I am shocked nobody has said Final Fantasy 7 yet; starts out zoomed into Midgard on Aeris picking a flower, camera pans back to reveal an alleyway, which becomes a busy street, which becomes a block of buildings, which becomes a sea of industrial construction and at last rests at a stunning(for the time) shot of Midgard with the title...then cuts to sparking train wheels, cuts back to Midgard zooming in, cuts back to train wheels, back to Midgard zooming in, wheels, Midgard where train tracks become visible, then a train pulls into view and as the train stops, the camera comes to rest next to it just in time for your character to hop out and begin the game.
Extremely cool.