Civitai is the de facto model hub for the Stable Diffusion ecosystem: thousands of checkpoints and LoRAs, many NSFW-capable, with sample galleries and on-site generation. If you self-host, this is where your models come from. Policy changes have tightened some adult categories over time.