I used to have some Stormy Mondays in an SG-type guitar, and I really thought they were great pickups. They're a bit too polite and smooth in the mids to do Hendrix style madness, but I think they'd be able to do the tones in that Santana clip. I have only had very brief use of Riff Raffs, but they might be a safer bet to cover more ground (particularly on the ruder and brighter end of the spectrum).
Actually, honestly, I'd look at Abraxas for the tones in that clip.