Hmm... For SID sounds there exists perfect solution called
HardSID.
For MSX-Music and MSX-Audio you can use MoonBlaster voice selector that accepts MIDI input.
For SCC there really is no way to play that with MIDI, but I think you should look for MOD/IT/XM or some similar tracker that accepts MIDI input. You can load SCC sample to it, set looping to 0 and there you go...