These are some of the more interesting examples of Stable Diffusion (link). All examples were run on locally hosted resources.