Hi Novaburst,
I think you probably know that Amigas don't use SID chips, only the C=64, and C=128. Thought I'd mention it just in case.
Trackers are really a quite limiting way to make music, but there are other more modern means of accessing SID sounds. Using your V-Drum setup connected to a MIDI sequencer/digital audio workstation, you can control a SID based synthesizer. There are several of these around, which use the original C=64 SID chips, with a modern digital control interface. My favourite is the MIDIBox SID, which can be found at
midibox.org (navigate to micro C apps, then midibox SID). This page also provides links to other SID based synths. Some of these require some electronics skills, and some are pre-made commercial products.
You may also enjoy the midibox FM synth, which I really like for ambient music, and I think it's a lot more versatile than most commercial FM synths.
If you are interested in the Prophet64, I suggest you have a look for some experimenters who have incorporated variable audio feedback into their double SID C=64's. Some pretty wild sounds from those old beasts.
If you are more interested in Amiga sounds (not really SID), then there are other options available for you to control Amiga audio with your drum kit. Other people here can advise you about interesting Amiga audio software and hardware (I don't actually use Amiga any more). I used Music-X 2 for many years on Amiga, which I really liked, but it was time to move on, for me.
Good luck. Hope you enjoy the retro sounds.
Oliver