The overdrive pedals that work best could depend on the guitar, pickups, amp and speaker(s). Most of my amps work well as pedal platforms, but one of them is more challenging. My VAC Hayseed 15 via 112 Celestion Blue speaker sounds great with any guitar and pickup, Strat, LP, Gretsch, SC, humbucker, P90, blacktops Filtertron. However, that amp is tricky with an OD pedal. I’ve come to the conclusion that the VAC, which is similar to a Vox AC15 circuit, simply sounds better with a bit less gain than my other amps. Too much gain from a pedal sounds lousy with that amp to me. The sweet spot is cleaner than my other amps.
My Fender Deville 410, VHT Fifty D through various speaker cabs, work great with most overdrive pedals as long as I pay attention to a few specifics with the guitars. For example, Gretsch guitars with blacktop Filtertron pickups work better with less gain. They just don’t sound good with a lot of gain IMO.
For me, a critical detail to get my OD’s to sound best with my amps is the guitar volume. An LP with humbuckers may not sound best with the guitar volume knob maxed. I’ve often got my LP volume rolled off to 7 or 8 to get the best sound from an OD pedal. With a typical SC Strat, I can set the gain much higher on an OD, but it often sounds better to back off som Strat volume and roll off some tone. As I already stated, with my Filtertron Gretsch guitars, I use less gain, and often prefer the guitar volume maxed.
Personally, I feel like I get along well with most OD’s. To me, asking what is the best OD is like asking what is the best flavor of ice cream. I like lots of different flavors. OD is my favorite type of effect pedal. Of course, I like amp gain as well.