Any Decent pickup will sound great through a Mesa. Here's my opinion (and opinions are like A$$%#L&s right?) I have a Studio 22 mesa and Subway Rockets. I play Maple FB "88 HM strats which have a Dimarzio super distortion and it can sound just like anything on any album i've heard. I have a Fender Highway One Tele w/stock fender Alnico pickups, I listened to some jam recordings and it sounds just like Jimmy Page, Chili Peppers, SRV. I've played friends stock mid 90's strat w/stock Single coins and it sounds great. Not that I think i'm that great, but the sound is. Pretty much anything decent you plug into a boogie will sound great.
I had a "fancy" Ibanez RG for playing out and that sounded like plywood and strings...not good. With a boogie and a decent guitar, you have the right tools... after that, the tone is really in your own two hands !!!
Gibson PAF pickups sound great too ... like in the Les Paul
Hope that helps !