The RY, the RR and the CS would fit in their own way here.
You usually canīt go wrong with a RR in an SG, does cleans, classic rock and can go really heavy into the metal terretory. It just goes with SGs soooo well.
The RY is my personal fav bridge PU, it is such pure rock. Punchy tight low end (its a bright PU but with enough low end to get you all you want), really great agressive and wonderfully organic mids (uppermids is the keyword here) and so many nice overtones in general, just a joy to me. I can take mine from blues to classic rock to 80s metal, to pop punk, to modern metal and back through all the allies.
Canīt really comment on the CS, as I only could comment on the neck, which is cited as one of the best neck PUs on the BKP roster for a good reason.
Just stay away from the WP in a guitar with lots of bass and mids. MM does the Zakk tone, after all it is named after him, but it is really heavy on the low mids giving it its power, which again whould probably be overkill for you.