I have a Stockholm, it is great with gain after a few teething issues that any BKP P-90 in that guitar might have.
Pros: the pickup is wax-potted, which helps a lot to reduce microphonics
Cons: The baseplate of the BKP P-90 soapbar would not fit the Gibson 'batwing' type mount (found on large pickguard SGs with P-90s, or basically any P-90 soapbar guitar with humbucker-style height adjustment screws through the pickguard) so I had to change the pickup mounting to a screw-into-wood type, then it was fine. This is not an issue for dogear or humbucker size versions
To reduce feedback issues I shielded the pickup and control cavities (as well as the underside of the pickguard and control cavity cover) with conductive paint, tested that the continuity was complete, and grounded to the back of a pot with a wire.
There remains some residual 60 cycle hum, but it is much better. The feedback issues arise either from microphonics in the pickup (unpotted) or a vibrating pickup mounting, or from the 60 cycle hum feeding back. Once these are all controlled the response of the pickup under gain is fantastic. I ran mine into the lead channel of a Peavey 6534+, which gives you some idea of the gain I was generating. It performed very well at all of the fifteen gigs I used it at.
The Nantucket and MQ would have less bottom end but will give you a more modern sound. I have to say though that I can get a very convincing Discharge sound with mine, even though that was originally achieved with a pickup similar to a Nantucket. If the guitar is dark and has plenty of bass already a Nantucket might be a better choice than a Stockholm. Mine is in an SG Junior, which is a bright guitar without a lot of bass.