This is something I am currently modeling and texturing using Photoshop. Also, trying to render this using Photoshop 3D. I am also thinking of putting together a tutorial on my workflow for using Photoshop CC 3D to texture a model. Watch out for it soon!