I'm not a GOOD artist, but with a little training, even I may improve
!
Perhaps you should try modifying existing sprites. Personally, I started this way, using ImageForge and the original units' sprites.
I found them following this thread :
http://forum.shrapnelgames.com//showthread.php?t=37793
And thanks to EricM !!!