I don't think the rebel yell will be as fat you want
it's definitely way better and more present than the 498t (as it's brighter and has a ton of mids), but not really hotter
I always disagreed with Tim over his SG advices, but now I understand his position
I always thought that the Holy Diver would be the perfect pickup for a SG and better than in a Les Paul
not that it sounded bad, but I was wrong
it sounded darker, more nasal and lost a lot of picking response on the low notes (it is very balanced and tight sounding compared to most alnico pups on les pauls)
medium output pickups seem to take part of natural SG sound, but aren't strong enough to put their own character over it
SGs don't have that treble sparkle of a Les Paul maple top and the flat top with bat pickguard doesn't allow the bridge pickup to be positioned in parallel with the strings like on a Les Paul, so the pickups respond very different
that's why he always repeat: for SG, go easy or go extreme
I'll keep the Warpig advice
it's not the monster you probably think
it's like a Diver, but more gritty on the mids and has a brighter top end
and it cleans up very well and sounds very thick on leads and rhythms without getting hard or harsh in any way
some bands that you mentioned may not use extreme pickups, but they all use boosters (except Clutch, I think)
the only downside that kept me away from a Warpig was exactly the fact that it makes everything sound Iommi-like, and unhappily, that's not what my bands play :(