The greatest levels that come to mind are both water temples in Ocarina of Time and Majora's Mask. In Mario Kart 64 it's the Rainbow Road hands down. For Perfect Dark, the Pipes level is the best for multi-player.