Yes, my Cold Sweat set works really well in my 2011 SG Standard.
The issues with SGs arise from the construction, which tends to produce a very resonant guitar focused on the mids, with a strong resonant peak somewhere between the 'mid-mids' and the low mids. Some pickups that are especially strong in that area can sound very honky and skew the sound of the pickup to the point where it simply isn't recognizable from the clips.
I had an A-Bomb with that issue, which is apparently quite common with SGs. Some atypical SGs that are darker sounding have not had this issue, or it has not been so pronounced, as in the case of BigB's. Personally I think pickups like A-Bombs and Painkillers that have strong mids are too much of a risk in an SG.
The other issue is a relative lack of bass. While the Rebel Yell set avoids the issue above it can feel lacking in bass in an SG as there is not a big bottom end (as in, say, a Les Paul or Explorer) in the instrument itself to fill that out. Then again your lower output pickups such as the Riff Raff are the same; the point is I guess that the RY will not feel so much like a high output pickup if you are doing a lot of chunky metal rhythm playing, that it will be more of a screaming rock pickup. It does avoid that mid hump issue though.
The Crawler and Holy Diver are to be avoided in SGs. They have a tendency to sound muddy for some reason.
In the high output range the Miracle Man has the best reputation with SGs, due to its 'scooped' character, which adds in bass and highs while the natural mids of the guitar lessen the scoop. The Cold Sweat is much the same, and provides better cleans and is generally more versatile in terms of its application than the MM, which is strictly a metal pickup. The Warpig apparently works well in SGs, both in alnico and ceramic versions, as the bassiness of the pickup is reduced by the brightness of the guitar. I've noticed a bit of a preference for the C-Pig even, which is a pickup that a lot of people find too bassy but seems to work well in SGs. The C-Bomb apparently works fine too due to its 'scoop' relative to the A-Bomb.
In general though the two contemporary pickups that are 'no-brainers' for SGs are the Cold Sweat and Miracle Man.
In the vintage hot range to be honest I haven't seen a lot of comments regarding SGs. I do remember that someone had a good experience with VHIIs, but it's hard to say how typical the SG was. I suspect that the Emerald set might be like the Rebel Yell, but possibly brighter, maybe too bright. I think I also read somewhere that the Black Dog works. I would avoid the Abraxas due to its similarities to the Holy Diver and Crawler.
Out of the vintage range it seems that most will work because the interaction between pickup and guitar seems to be less of an issue. People have had good results with Riff Raffs and Mules.
Don't forget too that the HSP-90 range all work well in SGs. In fact the clips for those are all made in SGs.
I'm going to test my A-Pig set in my SG next string change, just to see whether I might want to buy another SG to use them in.
