Also, if you don't mind spending some money, Digital Tutors and  Gnomon Workshop both have some outstanding video tutorials for using Photoshop for applying photo textures over UV maps and blending it all together.