The SG does work well in my SG Standard.
I had an A-Bomb in my SG and didn't like it ... a C-Bomb would have been a better choice. Generally for an SG a more scooped pickup works best because of the mids focus. That said, if you get a pickup with enough output that seems to override that problem. My SG Special is fine with the A-Pig in it. My Explorer was horrible with the A-Pig, really dark. There are a lot of things to consider with choosing pickups, especially BKPs as they are very 'open' and this makes them more sensitive to the acoustics of the instrument you place them in.
With these '90s Les Pauls it seems to be the case that they can suffer from 'boomy neck, thin bridge' syndrome like you get with SGs (in that case mainly because the pickups are relatively close to one another) due to weight relief and can do with a bit of extra beef in the bridge slot. I fitted an Emerald set to an early '90s LP Studio and it seems to be a little lacking in output at the bridge. The CS or C-Bomb would be unlikely to have that issue as they have a good bottom end thump to them.
It's hard to say which pickup is more 'metal' ... I think the CS can probably do a broader range of styles than the C-Bomb. It can cover anything from old Judas Priest and Thin Lizzy through to Metallica and Pantera. The C-Bomb does a good job of stuff like Slayer, Sepultura, Possessed, and Machine Head, and can generally do '90s styles very well. The Cold Sweat is more '80s.