If it counts as retro, I think my overall favorite piece of VGM is "Moon Beach" from the first Streets of Rage game. That's stage 3.
For RPGs, "Rise or Fall" from Phantasy Star 2. That's the battle theme. Despite hearing it every 3 seconds for 92+ hours, I never got tired of it.