Never played around with it myself, but from what I hear it is best if you can run it locally, especially if you are planning to use it for generating NSFW content. Requires a relatively beefy GPU though.
The folks generating this content over on r/unstable_diffusion on Reddit are very helpful and often post tutorials about their workflow for how they achieved these results.