The problem is, is that I cannot make my own sprites and tilesets. I suck at art. And I have no clue how individual programmers make small, basic games without an artist's help!? What do you guys do? How can I get at least good looking 2D art as sprites and tilesets?

Scirra has an asset store from which you can purchase game art; also check out the asset store at the unity3d site.