Paul, my Energy Hook partner-in-crime, has been teaching texturing at Digipen and, while teaching, has made several tutorial videos:
- Making a tiling texture out of a nonuniform brick wall.
- Making a normal map out of tree bark. (Should be good for any photo where it's hard to tell shadows from natural color.)
- Layered textures and multiple UV sets. (The favorite.)