Comfy UI lets you run stable diffusion locally and has 75k+ stars on GitHub.
Comfyworkflows lists example workflows.