I had exactly the same thought! I've got a game I've been wanting to build for over a decade that I recently started working on. The art is going to be very challenging however, because I lack a lot of those skills. I am really hoping the AI tools can help with that.

Is anyone doing this already who can share information on what the best models are?

Use the imagegen skill in codex and ask it to create sprites. It works really well.