I have:
Gibson P90s
Duncan Whole lotta Humbuckers
DiMarzio 36ths
DMZ Transitions
DMZ Norton
DMZ PAF Pro
Duncan Custom 5
Gibson Iommi Humbuckers
DMZ P90 sized Super Distortion
Fishman Fluence Humbuckers
DMZ Tone Zone
Fender Noiseless Gen 4 Strat
Right now, my best sounding guitar is a MIJ Les Paul by a company called FGN which is not well known here in the US. I think I paid like $1200 USD shipped from Japan last year. Not an expensive guitar. The pickups are stock and they are "Alnico V proprietary". I will never sell this guitar.
I have an RG with a Tone Zone in the bridge that sounds KILLER. I had the same pickup in a Les Paul and it sounded like ass.
The Gibson Iommi pickups are fire breathers and sound great but are not very versatile.
My favorite aftermarket humbucker is the DMZ Transition (Steve Lukather endorsed) bridge pickup. It is ceramic but not super high output, and the subdued low end is nice. It has worked in every guitar I have put it in.
Hard to go wrong with a Gibson P90 also. I like P90s better than any Gibson PAF style pickup.