One of the problems is the idea that AI do everything with a prompt. While at first it may look like that, a prompt is not enough to make a useful (not just pretty) but useful asset.
I, for example when I need it, I like to draw what I want in Krita and then use the plug-in 'Krita AI diffusion' to do a refinement, (Imagine is like a filter with steroids). That way I can keep not just consistency, but control in I want to make.
Creating an actual good piece of art using AI (both pretty and useful) also takes a lot of effort. Perhaps not the same as fully drawing from scratch. But what you gain is speed, quick modifications (good for brainstorming), and drawing in a style that's not actually possible by hand. For example, imagine drawing a photo-realistic sprite by hand in a couple of minutes.
There are also tools that just limit to specific stuff, like auto colouring, up-scaling, background removal, face modifications, etc. Not fully generative, but assisting but any form of AI in the end.
It's too early to say if anybody is good or bad with AI. Perhaps, if you tried to experiment with it the problem is you tried with the wrong one? I mean, one that didn't went well with what you tried to do?
I made a post in the other section talking briefly about tools: https://itch.io/t/6524872/sharing-some-ai-tools-for-artistlearners-or-just-speed...
I'd like to invite you (and any other that read this) to take a look. Is not great, but perhaps it may help a good starting point to face this new world we may be all facing.
Sorry if the response is too long. haha. I need to learn when to shut up.