Any Nvidia GPU with at least 6GB able to do the job. You can follow this comprehensive guide here to generate these AI-generated images: rentry.co/voldy
This is the super-big lists of Stable Diffusion models: rentry.org/sdmodels
Keep in mind that old Stable Diffusion version 1.5 still suitable for generating NSFW art while latest Stable Diffusion 2.0 completely nerfs it unless somebody is willing to build unstable diffusion 2.0 with NSFW feature regained.