I'm not very familiar with Children of Bodom, and in any case I'm not very good at picking "these pickups for that sound", but I will say that Cold Sweats sound great in an SG.
In the bridge, the CS is bright - but not thin like your 490T(?) probably is. Bright, but with enough power to give a tight, balanced sound with no "mahogany flab" at all. And the neck model gives a lovely warm, singing tone, a great contrast to the bridge.
Nothing against the Riff Raff, but it's more of a classic AC/DC sound, bright and quite "dry". I can't comment on the high-output models.