My experiences are very hit and miss, but mostly miss. Creating something decent with an AI is hard. Sometimes you get a great-looking character or environment, but most of the time you really need to fight the prompt and inpaint every detail, and repeat the same thing dozens of times.
For example I made this superheroine version of a space marine in Stable Diffusion:
You can make standard superheroines by using their movie counterparts, which most AIs understand:
The worst thing is the available models have been heavily curated and do not understand a single thing about sex, peril, or bondage (not even mild things you'd see on TV: words like tied, chained or handcuffed are either banned or useless since they are not in the training set).
I've been trying to force the AI to produce some peril scenes with little luck. You can try to force it using image to image techniques, but the end result is poor IMHO and looks photoshopped or wrong. Here is for example my attempt at a buried alive scene:
You *can* use AIs to get NSFW results, in part because dedicated people have been training models for that. In fact, a NSFW model improves everything because it produces better hands and bodies (just like drawing better bodies requires you to study nudes for anatomy).
Any thoughts?