My favorite song of any game all-time is Bloody Tears from the Castlevania series. There isn't a version of it I don't enjoy.
I'm partial to all the SNES RPG music too (FFIV, FFVI, Chrono Trigger) because I grew up with it, but the Mega Man series has been stellar through the generations. That is actually how I discovered Smooth McGroove on Youtube.