Learn ComyUI. There are a ton of models customized around NSFW content and you can probably even find existing workflows people have set up and made available. There's a huge community and plenty of people doing exactly this kind of thing.
Here are the challenges; running things locally gives you the most freedom and there's zero cost, but it's really tough if you don't have a really high end GPU. To run newer models, more complex workflows, or generate video, you might need to set things up to handle all the compute through a cloud service. Getting consistent results can get difficult and might require training your own LORA for it.
That all said, it's a lot of fun to use and I highly recommend playing around with it, even if it's just to run things locally while you get the hang of the whole thing for now.