Hi Grim - and congrats for the axe 8)
The general wisdom for SGs is to go for either low output or very hi output pups, as "vintage hot" ones tend to muddy up in an all mahagony guitar. And unless your SG is specially bright sounding, you may want to avoid Black Dogs which already have a fair amount of low ends.
In the low output category, Riff Raff (of course) - possibly with a bigger magnet and extra winding, cf Eric Hellstyle's posts for this -, Stormy Mondays and AV Mules are the most common choices as far as I can tell. Don't remember which hi output pups are known to work well with SGs, sorry (not really interested in hi output pups as far as I'm concerned...). You may also want to have a look at HB sized P90 (MQ anyone ?).
Now all this comes from "which SG pups" posts here - I've been reading quite a few of them recently since I'm also looking to replace the pups on my own SG - so no direct experience so far, but I have good reasons to trust this forum's "general wisdom" and Tim's advices :mrgreen: