The Cold Sweat has more low end beef and more scoop in the mids than the Rebel Yell. The RY is upper-mids focused with a tight low end. Either works well in an SG type guitar. My SG has a Cold Sweat and it sounds great, and Heket has an SG with a Rebel Yell set that she really likes. These are really the two out of the slightly lower output end of the contemporary range that work well, and then there are the Miracle Man and Warpig in the high-output category. People seem to be really pleased with the MM in SGs and there seem to be quite a few C-Pigs in them.
If you like Randy Rhoads apparently the Rebel Yell set is the closest, and might well be closest to a lot of the hard rock ones you have listed. The Cold Sweat is more of an '80s metal voicing but also does '70s stuff like Judas Priest very well, and apparently is the go-to pickup for Pantera sounds but don't let that put you off, as it is quite versatile. It is closer to the Metallica sound than the Rebel Yell. The Miracle Man is famous for its early Zakk Wylde sound and does Metallica maybe a bit better than the Cold Sweat. I think you will find though that the Cold Sweat and the Miracle Man can be seen as on a spectrum, with the CS being cleaner and more precise while the MM is bigger but still very tight, and maybe a bit more scooped.
I'm very happy with my Cold Sweat set but if I were to buy another humbucker SG I would try the Rebel Yell or Miracle Man sets.