I've actually never screwed with Capcom's C4 chip, so I'm really not sure about the compatibility with those games. Never messed with SDD-1 either (Star Ocean, SFZ2, etc), though I'd love to see someone find a way to make that translation work with a game copier.
With the DSP chips there's 4 different revisions so you may need to have a couple of different carts, depending on what you want to play. I know the DSP-1b is supposed to be the best (found in Ballz) because it's a bug fixed version of the DSP-1a, which is a bugfixed version of the DSP-1. DSP-2, 3, and 4 aren't that common and were really limited (Only Top Gear 3000 used DSP-4, Only Dungeon Master used DSP-2, and some Gundam game used DSP-3).
SuperFX stuff is a bit simpler. Starfox 1.0 used the earliest version (Mario Chip 1), later revisions used the next version of Mario Chip 1. The other SuperFX games used a different chip (GSU-1), and then afaik SuperFX2 stuff all use the same chip (GSU-2).
Don't recall screwing with any other chips...so...hope that helps a little bit.