I've been more messing with DALLE and in those specifying style is really useful. For SD I think the best thing is to follow some of the Twitter accounts that are posting prompts with their images (though they aren't posting other settings usually). Twitter on my computer is not working right now so I'll try to remember to come back later.
But suggestions I'll give is that you need to add detail to the prompts. SD also has negative prompts which really help. So use a lot of words if you can (twitter accounts will help you find magic phrases like "bismuth neon chrome copper patina verdigris"[0]). But you may even see here that the magic words with SD aren't as simple as with DALLE
I do think you're understanding, though, what my post is about and why I think a lot of people are talking from a naive perspective. If you only show the wins you have some extreme biases.
Interesting magic word. My prompts were often full of 'masterpiece' or 'octane render' (which improves 3D consistency).
With regard to your main point, I generated more than a thousand images trough various models, and yes good results such as these posted on social media are very rare. And people definitely spend lots of time to adjust things with inpainting and other tricks, in a way that I would find infuriating. For the effort it takes I would rather just redraw it. It depends on the styles; with brushstrokes you can hide a lot, with cartoon lineart is crucial so fixing requires more work.
I even tried to use DreamBooth to train on my own inputs and the results are not really usable, and that was with SD1.4 and AnythingV3 as base models.