You can click a few buttons and instantly get artwork that is indistinguishable from stuff made by professional artists for top-quality games. Amazing!
The downside is, your game is indistinguishable from every other game. Close your eyes and pick out anything in the isometric sci-fi/cyberpunk genre from Steam and the result will look exactly like this one. Heck you can probably import it directly from Unity's asset store without even bothering with Stable Diffusion.
There's the broader question of – what is AI adding that will appeal to people wanting to buy your game, and the answer to that is still probably nothing.