Heres a current shot of the door for the sci-fi scene I'm working on. I used Photoshop and Crazybump with a combination of hand painting and layering photos. It still has a way to go but I'm getting to a place where I'm seeing some good results and happy with it! This is one of four panels in the scene.
In Maya