It seems to me that the only reason the A-Pig is not an issue with an SG is its sheer output. But in general a more scooped pickup like the C-Pig is better suited to the SG's natural frequency characteristics. SGs have a 'mid hump' built into them and thus mids will sound more pronounced. With certain pickups that have a strong mid range - such as the A-Bomb or the Holy Diver - but are not powerful enough to overcome the tonal characteristics of the guitar you get a kind of butting of heads in terms of frequencies between the guitar and the pickups. Apparently with the Holy Diver this results in 'mush', in the A-Bomb it can produce a very 'hairy' and 'aggressive' sound, much more so than when used in some other types of guitar. What you need is to somehow get out of the way of that hump. The Crawler is another one to avoid. No idea on Blackhawks. I would avoid the Painkiller. I tend to think that it would react like the A-Bomb, making a very aggressive and thus somewhat one-dimensional guitar. I've heard a couple of clips and it sounded very much like that.
This is why I think there have been some positive experiences with the Rebel Yell set. It has strong mids but they are higher than the A-Bomb mids. The natural mid hump of the guitar then sits below the pickup's hump, rather than coinciding with it. This is a set to inquire about, I've read good reports on it here and at the US seven string forum (where there is a lot of BKP talk).
I have seen good reports on various vintage hot pickups in SGs too, but these have been so far and few between (because people do not seem to try them) that I find it hard to recommend them. Out of the Vintage Hot range the one that I think was bad in an SG was the Abraxas (again, another pickup like the Holy Diver and A-Bomb that has a great reputation for versatility in other types of guitar). I've read vague things about someone having used the Black Dog (maybe twice) and VHII (once) and being happy, and the Emerald might work though I haven't read a report on it in an SG.
I haven't seen any bad reports of the vintage pickups in SGs, probably they don't have enough output in the mids to cause an issue.
I can tell you though that the Cold Sweat is a huge improvement on the A-bomb in my SG for all kinds of rock and metal except for hardcore/crossover, and manages hardcore quite well, although it is not as aggressive and hardcore sounding at the A-bomb/SG combo the latter was a one-trick pony.
I've read good reports about the C-Bomb, and judging by the EQ charts I can see why it would be better than the A-Bomb.
People tend to suggest that the A-Bomb will give you a more vintage sound due to it being alnico, but if I were to choose an alnico pickup for an SG in the mid-output range it would be a Rebel Yell set. The Cold Sweat set is also an excellent set, it has a ceramic bridge but the cleans are excellent - I prefer them to the cleans that I was getting with the A-Bomb in the same guitar.
Overall the Rebel Yell set is warmer and more 'rock' sounding than the Cold Sweat set, which is more 'metal'. Either seems like a good option, based on my experience with the A-Bomb and Cold Sweat and what I have read here and elsewhere. Ben recommended both the Cold Sweat and Miracle Man to me, calling the Cold Sweat 'the pro's choice' for its clarity and range, whereas the Miracle Man was a high-output recommendation if I wanted more output, but it is equally good (besides cleans).