ok, I'm gonna go with something a little different here as you've asked to retain a little twang - ask Tim about doing a Pig90 in a MQ package (i.e. P90 in a humbucker casing). If he can coil tap it too, that would be even better so you can have a lower-output option with more of a traditional P90 tone.
The Pig90 is a cross between a P90 and a Warpig - there is someone here on the forum (sorry, can't remember who) that has done some great doom recordings with the Pig90.
With any other single coil, I think you'll miss the low-end chunk (even with a Piledriver).