Honestly, the P90 is one of my favorite pickup sounds. Just wish there wasn't the hum. I know that they have all these "hum free" versions, but they are never quite the same. Then there's the staple top, which I have unfortunately not gotten a chance to really own. I have a Jazzmaster, and also like the sound of those pickups, but again, wish there wasn't so much hum.
My favorite humbucker pickups are always the vintage style ones with lower output. Yes, they don't push the amps as hard, but they just have a type of snarl that the higher output pickups lack. I'm fine with SD '59s, Seth Lovers, or Dimarzio 36th Anniversary PAFs. While I admit the high end PAF style pickups are enticing, I feel the law of diminishing returns is definitely in effect.