Some amazing examples of what people have done with img2img with Stable Diffusion:
https://old.reddit.com/r/StableDiffusion/comments/wy7oa5/img...
https://old.reddit.com/r/StableDiffusion/comments/wyq04v/usi...
https://old.reddit.com/r/StableDiffusion/comments/wzlmty/its...