I tend more toward vintage humbuckers in that category; alnico, both potted and unpotted have worked well with different guitars.
I like a good vintage sounding P-90; I learned to play on a '65 SG Special with original pickups, and it feels kind of natural. The Duncans they used on the 594 Soapbars are pretty dang close.
The 57/08s, 59/09s, 53/10s, 58/15s, and 85/15s have all done a great job here. So have the Paul's Guitar and 408 pickups.
So much depends on the guitar, the mood, whatever.
The earlier pickups, like the Dragon I, Dragon II, T&B, Deep Dish, original McCarty, 7s, 6s, or a few other PRS pickups didn't really appeal as much to me. Doesn't mean I think they suck. Just that other types seem to work better in the context of the music I create.
In other words, there is no 'best'. There is only what works for you, and what works less well for you.