Game Art for Programmers: A System, Not Encouragement
The standard advice is use cubes, pick a genre without art, or spend two years learning to draw. Here is the other answer: convert the aesthetic problem into a spec problem you can already verify.