As a hobby dev I would like to use AI assets more because I can't draw and using store assets limits my creativity. But I'm unsure whether I would actually use it a public product because there are so many people opposed and I probably don't have the patience for managing a shitstorm.
My suggestion would be to commission someone to make some stuff for you. I'm sure it'll take a while for the market to settle, but before long there'll be people good at getting AI to spit out something they can edit in 10 minutes into something that would have otherwise taken them hours, thereby cutting the costs down to something affordable. People without any practice drawing are going to miss all the little things that pop out to artists and make them bitch about how they can't get hands quite right or always draw the same pose.
I think in the long run too, we'll end up with way more and cheaper store assets. Part of the problem with AI is trying to get it to give you something that fits with existing style. If all you want to do is say, generate fantasy portraits or backgrounds and give zero fucks about consistent style and just curate/edit out flaws, you can create a massive library of stock assets to sell for dirt cheap. Someone's going to make a fortune on that with a dedicated website probably.