Deffo! I run my models on a 3070 with comfy-ui in low vram mode so it uses my DRAM as well, you need a good amount of DRAM if you’re doing it that way though, I have 64 gigs and still get OOM errors when using dram for AI models.
The 4070’s 12 gigs of VRAM should cut it though!
If you have a decent GPU - check it out https://github.com/lecode-official/comfyui-docker
Look at civitai and huggingface for models to employ. The Hentai type generators are easy to employ in places of any other image generation model, if you want specific poses you can use lora networks to modify the output, if you want video you’ll want to look into hunyuan video or something of that nature, keep in mind you’ll need big VRAM for that, I recommend using a smaller quantized gguf for hunyuan video generation because it can break the process into smaller chunks at the expense of longer processing time.
I highly recommend using Docker, it’s probably the easiest way to set it up if you’re a linux or intel mac user.
Alternatively: Comfy.org has the windows and Apple Silicon versions as executables.