I was actually thinking of writing a post on tips about how non-artists, particularly programmers, can create art for games (I've always been moderately happy with the look of my games despite having near zero art skills).

In the mean time, I suggest downloading the torrent of Cactus's GDC presentation (Despite being incredibly avant-gante for what is supposed to be an educational lecture, it contains detailed info on how Cactus creates his unique art styles). It's apparently floating around on a certain Scandinavian torrent tracker.