my all around fave now is the Custom Custom, with a 59 in the neck
The SD Custom Custom is one of my favorite pickups, too. I usually pair it with an Alnico II Pro in the neck, but the 59 is a great choice, too, and is just my personal preference.
@Shepdoggiest , I have 8 Les Pauls and gravitate towards Marshall and Marshall-like amps, both in the AFX and tube amps. IME, pickups make a bigger impact on sound than the wood does.
For me, a guitar must speak to me before I'll take it home. Mostly, it's the way the feel and how well that matches up with my playing style. I almost never plug one in when trying it out for the first time. I figure I can adjust pickups and wiring if need be, but it needs to feel good and sound good acoustically if I'm going to keep it. So, the wood and the construction definitely matter to me, but I try to take it as a whole and have changed a lot of pickups along the way.
If this helps, here's a run-down of the LPs I have at the moment...
'77 Les Paul Artisan 3pu - solid; Bareknuckle Crawler (bridge), Mule bridge (middle), Mule neck (neck)
'93 Les Paul Studio - weight relieved; stock 498 (bridge), 490 (neck)
'99 Les Paul Custom - weight relieved; SD Distortion (bridge), Alnico II Pro (neck)
'02 Les Paul Standard - weight relieved; SD Custom Custom (bridge), Stormy Monday (neck)
'03 Les Paul Custom '57 RI - solid; Bareknuckle Rebel Yell (bridge), Stormy Monday (neck)
'03 Les Paul Custom '57 RI - solid; Bareknuckle Black Dog (bridge), Stormy Monday (neck)
'05 Les Paul Junior - solid 2-piece; Bareknuckle Nantucket P90
'21 Les Paul '60 RI - solid; stock Custombuckers (both)
I'm not sure I could pick a favorite. They'll all do 70s/80s rock, but are all different, too. The R0 is the most aggressive because it has the most attack and the low-output CBs accentuate this. The R7 with the high-output Rebel Yell just screams (think John Sykes). The other R7 with the moderate-output Black Dog is more like the R0 but more compressed and a fuller tone. Both R7s are all mahogany, too, no maple top but ebony boards, and have less attack than the others. There's a bigger difference between the all mahogany ones than there is between the weight-relieved and non-weight-relieved ones. I might say the Artisan has the best unplugged sound, but it's a close thing with the R0; both are maple-topped and non-weight relieved, but have different fretboards (R0 is RW, Artisan is ebony). I don't have a chambered LP, but do have some semi- and full-hollow bodies and typically favor low to medium output pickups in those. Bottom line is that, to me, wood has an effect, as does construction, at least in my ears, but not nearly as much as the pickups. Just my opinion, though.
In general, I think that, other than the player themselves, speakers (and/or IRs) have the biggest impact on tone. Amp topology is next (e.g. Marshall vs Fender, MV vs non-MV, number of gain stages, output transformer), followed by pickups, then everything else to a lesser degree (wood, construction, design, strings, picks, cables, humidity, et al).