I'm gonna throw a curve ball here - I've had RRs and MQs in my SG (and the stock Epi things, and Gibson ceramics) and basically, even with SMs (which I've not tried), I cannot imagine me getting that tone out of my SG with any pickups...
All of which got me thinking, and watching ole Frank's fingers - he has what I'd call a light touch (compare him to SRV maybe?).
I reckon it's a case of, like Philly said early on, "not unless you're Frank Marino"...
I use 11s on my guitars, and as a general rule I dig in quite hard to get the tones I want - nearer to the Rory/SRV approach than this clip was showing (live, I always used to break A, D and G strings, very rarely top Es). Frank Marino doesn't appear to be digging in like that, and I'd guess his strings are somewhat lighter than 11s?
Anyway, I believe, with strings in the right ballpark, that Mr Marino would get that tone out of my SG with RRs or MQs - closer with RRs, but not much different though - and he'd go "hey man, nice pups..." (or somethying similar :lol:)
Now, the clips I've heard of yours Hunter - I suspect your touch is nearer Frank Marino's than Rory/SRV, so I think you've got a better chance than me!! :D
In my experience, the MQ neck was just a bit fatter than the sound on display, and the RR is a bit "thinner" - so maybe everyone's right about suggesting the SM neck (but I've not tried one).
I'm not sure I've seen this recommended much, but I personally would then consider the MQ in the bridge, because I think it kicks @rse there :lol: In many ways I find it more usable than a humbucker bridge. It gets close to a humbucker sound but without restricting you to the "it's a bridge humbucker - what else did you expect? :roll:" problem. (Remember I'm a Fender player at heart, and bridge humbuckers seem something of a "one-trick-pony" to me - a nice trick, but only one :D)
I agree that a P90 doesn't quite have that compressed "crunch" that a bridge humbucker gives - but that's what "digging in" is all about when you're playing the bottom ends of chords for tight rhythm on single coils, you have to do it that way on a strat, say, so I don't tend to notice the lack on an MQ bridge.