I generally spend at least as much time on my textures as I do on my model. Usually, however, I end up spending 2 to 3 times as much time on the texture (and that doesn\'t include time for the uv unwrap). If you suck at textures then I suggest you check out some other people\'s textures and see how they made them. Let me get you started >
StrangeFate - This guy just does awesome work all around, this link is to a few of the materials he did for Unreal Tournament 2k3. He shows his different layers and how he blended them. Note that this is just for tileable textures.
Bobo the Seal - This is a skinning mini-tut by a guy that has done contract work on more games than you knew existed (though he now works at Iron Lore).
poopinmymouth - This guy is my hero. Look at his texturing tutorial, texturing theory paper, and his jpg on dirtying up textures.
There are tons of other links on Bobo\'s site you can look at. Remember, texturing isn\'t something to take lightly, it can literally make or break your models.
Edit: I changed the URL on the strangefate link because he doesn\'t want people linking directly to that page for some reason. It\'s simple to find though, from the index go A (art) > ? (tutorials) > bottom most tutorial.
:emerald: