I have a Black Dog in my SG and it sounds great; tons of mids, obviously, but nice top end. The RiffRaff would be the obvious other candidate.
Before the Black Dog I had a Miracle Man in there and that rocked a lot, in fact I think that the MM is the perfect match for SGs and metal. I only changed it because that guitar is not my "metal" guitar, but more my "classic rock" guitar.