I think you might not go far wrong with Stormy Mondays.
I'm a strat-man really, but I have a bunch of other guitars. Recently I got a Les Paul Traditional and thought I'd try out the Stormy Mondays (I have Mules and Riff Raffs in other humbucker guitars). I have to say - this guitar has completely stopped me playing the strats for the moment. It does the cleans, it does the rocking. It's fast turning into my favourite go-to guitar.
If you want to go P90, I have Mississippi Queens. They were in an SG for a long time, they're now in another Les Paul but I haven't used it much yet (all the pickups got switched round at the same time, and apart from a little run-through and adjustment for the others, I haven't put the Trad with it's Stormies down). The SG with the MQs definitely produced the sounds you're talking about when I rolled off the volume - nice cleans that encouraged funky blues playing. But I find them slightly harsher and more punchy than the Stormy Mondays.
The SMs have been a bit of an eye-opener for me - I use a single channel valve amp, no pedals, I control it all from the guitar, and prior to this, if I wanted a "versatile" sound, cleans and dirties etc, the whole thing, mellow, funky, raunchy, I'd always pick up a strat or a tele. The guitars with humbuckers or, indeed, the MQs always suggest dirtier blues/rock etc to me. But I'm now using a Les Paul with humbuckers (Stormy Mondays) for everything. It doesn't sound like a strat, but it gives me the same vibe.
How things will work with a mahogany body and bolt on maple, I don't know, though...