My favorite musical motif across the rich history of music in video games is, without a doubt, Corridors of Time by Yasunori Mitsuda from Chrono Trigger. Here's a great performance of it that's absolutely worth 3 minutes of your time. https://www.youtube.com/watch?v=UKCWgkJCU3o