Perfect Dark - The DataDyne building was just dripping in the atmosphere and stylization of the game that unfortunately just kind of vanishes soon on after. And was also by the far the game's best effort at actually having stealth mechanics in an era when that was still fresh and novel.
Star Fox (either one, though 64 is just the original but actually on hardware that can render it well). A solid intro and right into the thick of things. Tutorialization is done efficently and in mission.
Final Fantasy 7 (the original, not FF7:R which does quite the opposite) : Whether just the first dungeon or if we consider it the whole of Midgar/Disc 1. One of the best paced and most atmospheric intros in the series, if not in gaming in general. For something that was effectively the prologue, the Midgar section did a great job of keeping pace and building things up, all leading to that final escape into the world (and the first glimpse of any actual daylight, in the original)
Star Fox (either one, though 64 is just the original but actually on hardware that can render it well). A solid intro and right into the thick of things. Tutorialization is done efficently and in mission.
Final Fantasy 7 (the original, not FF7:R which does quite the opposite) : Whether just the first dungeon or if we consider it the whole of Midgar/Disc 1. One of the best paced and most atmospheric intros in the series, if not in gaming in general. For something that was effectively the prologue, the Midgar section did a great job of keeping pace and building things up, all leading to that final escape into the world (and the first glimpse of any actual daylight, in the original)