You could also check out a book called "The Dark Side of Texture Mapping"....I think thats the title anyway. I picked it up at GDC and its a pretty good buy. It assumes you have no freehand artistic skill, thus teaching you photoshop tricks to the hilt.
But you still need that freehand touch if you want you're textures to look like more than a heap of photoshop effects:P hehe
But you still need that freehand touch if you want you're textures to look like more than a heap of photoshop effects:P hehe