Units are going to be difficult, villagers are something like 10 pixels across - getting them to pose correctly will be hard. However, there is someone doing something similar with the original Mortal Kombat sprites who is having a lot of success -
https://www.reddit.com/r/StableDiffusion/comments/13jllfh/qu...