Generally speaking, SD runs normal pictures. If the user is not experienced enough, the results will most likely be worse than NOVEL AI and midjourney. But SD is valuable because of its strong plasticity. If you spend a certain amount of effort to understand its principles and train LORA and ckpt well enough, then SD can realize most interesting tricks that the human brain can come up with.