I’ve used both DALL-E and stable diffusion extensively, and in my experience DALL-E is more forgiving while stable diffusion is more powerful — with a much higher skill ceiling for writing prompts.
Also, stable diffusion’s open source weights are great for self-hosting which can’t be done with DALL-E.