I use stable diffusion all the time for clean up and matte paintings. I usually access it through A1111, DiffusionBee (low-key an amazing SD tool-set for mac) and Invoke.ai.
Pika labs and Genmo for abstract design elements.
AVC labs for up scaling video (great for anything with faces)
Runway for pretty much everything else