I always recommend trying to keep the output low on SG's as medium output pickups mud out with all that mahogany, hence my Riff Raff suggestion.A high gainer like a Warpig sounds good and so does a Miracle Man as both have more than enough power to really drive through timber.Funnily enough I fitted a Stormy Monday to a friends SG and that sounded really nice too......quite a surprise but it chunked up really well into an overdriven Marshall.
The ones to avoid are the medium output humbuckers as they simply seem to add to the bottom end of the mahogany.So I wouldn't bother with VHII,Emerald, Crawler or even a Nailbomb as that's got a big bass response too even though it's quite high gain.