Quite a range of things you're after there so it's difficult to know where to start. First of all, everything in the Bare Knuckle range is highly articulate, regardless of the magnet used so don't worry about that. As with everything to do with guitars, there may be an element of compromise.
The Cold Sweats do really well in mahogany guitars and will broadly give you a tone like John Sykes (not entirely surprisingly!). However, it's not what I would call a 'fat' sound, which is what you say you like and neither is the Aftermath from what I've heard.
The Miracle Man is something of a 'go-to' Metal pickup and will serve you well. It has a fatter sound than some other ceramic pickups, especially in the lows but I wouldn't have called it very versatile. It's very much a Metal pickup.
The Nailbomb is quite a cutting pickup, especially in ceramic format. If you want a fat and thick sound I'd look more at the Alnico V version and even that is pretty cutting in a way that you normally associate with a ceramic pickup but it is a very versatile pickup and will give you a more organic tone than the C-Bomb.
The fattest and thickest sound, without going OTT with the wind, is the Holy Diver. It's very articulate and probably the most organic sounding contemporary pickup. Not sure how it would do with drop tunings but Antag should be able to help you out there as he seems to be the world authority on this pickup. I know you said you weren't interested in cleans but for what it's worth, the cleans on the Holy Diver are apparently really sweet so again, it's a very versatile pickup.
The Warpig will certainly give you those fat and thick tones you're after and loves drop tunings. Hell, it sounds drop tuned even in standard E! The ceramic version is particularly brutal but loses some of the sweet organic tone and versatility of the Alnico V version. The A-Pig is also a VERY articulate pickup. If you want 'BIG' then the Warpig in either form is the daddy.
Finally, as you've mentioned pickups like the Aftermath and Cold Sweat that aren't particularly 'fat and thick', I'd like to throw in a Rebel Yell as a suggestion from left field. Power is similar to the Cold Sweat and it's Alnico V but it's a beast of a pickup. The Alnico magnet gives it a very organic tone but it's also super tight like a ceramic and works really well in mahogany. Listen to the clip by Steve Stevens and you'll see what I mean.
If I had to pick just one of the above for you I'd guess Warpig but I think Miracle Man, Nailbomb, Holy Diver and Rebel Yell are all worth a look.
