I've been learning Blender and have made some decent progress. I've made some neat models, but so far, they haven't been textured. I understand how to unwrap a model so as to get the UV coordinates, but how do I actually create a texture to fit this coordinates? I've looked around and so far, it seems like a lot of people spend time hand-painting their models. Then I look at games like Counterstrike: Source, Call of Duty, etc., and I'm wondering how their models look photorealistic. It's all a bit of a mystery to me, but I'm hoping somebody could clarify. So, how exactly are photorealistic models created?