I feel like it's a good tool for people like me who cannot draw at all and can be used, yes, but honestly it's more about the effort for me.
People often say "AI slop" because it's generic, looks strange even when you can't quite tell why, not many worry about keeping the characters looking the same in each picture, and the overall laziness that comes with it is outstanding. Because it's easy.
In games people think they can get away with some random pics with hot scenes, but then they have awful story, terrible dialogue and, even though it's easier to generate them than it is to draw them, they end up with less scenes somehow. So it's just a slideshow of random characters you can't recognize by the end doing stuff.
If you can give me plenty of scenes, dialogue, choices, actual gameplay in certain genres, good characters and a pleasant flow of the game, then I will absolutely overlook the use of AI because there was still effort, but maybe the person can't draw or the artist they felt worked was too expensive, whatever. I get that. It's a good tool, but as with every good tool, it's abused.
Also, some artists do have weird styles and some might not be as polished, but there's still a charm to them. They take time to get better. Some post the same drawing they made five years earlier and show their progress and that's great, so I'm not going to point fingers at those that post their beginner drawings online, everyone starts somewhere.
However... I do have to say that even though I can be okay with AI, when it comes to choosing I will always go for the actual drawing and not the AI generated image. I simply respect that effort.