I have used Custom Customs in many of my guitars. They are alot more balanced than the Duncan tone chart would seem to indicate. They have a great, smooth, lower-mid bump that lends itself well to a kind of "brown sound". I used one in my LP Custom for years until I just switched to a Suhr Doug Aldrich set. The Suhrs are more aggressive but I still would not hesitate to use a Custom Custom in any guitar.
I had one in my SG Standard and it worked fairly well but I need some more low end and swapped it out for the new Duncan Alternate 8. I have to say I like the Alt 8 better. It's more articulate but still has a nice punchy low mid.
If you are looking for something that is dark and warm, the Custom Custom could certainly work. I'm not a big Dimarzio fan but the Tone Zone may also work.