While these videos aren't full on tutorials, they still walk through the my work flow of creating this illustration. As you will see, 90% of my time was spent in Photoshop.
Part 1 looks at applying textures. I used the Sketchup model rendered with Kerkythea as a base image. The Kerkythea rendering probably took about an hour to set up and 20 minutes to rendering. The entire rendering from beginning to end including Photoshop post processing took about 6 hours to create.
The illustration was created for Paul Lukez Architecture and represents an interior view of the Jindu Pavilion. More on the project can be found at http://www.lukez.com/