Blender is a really versatile program. It can even be used as a replacement for image manipulation programs like Photoshop in some cases, with the added benefit that real and fake 3D can be combined.
This QuickStart video covers some advanced material workflows including using triplanar texture mapping as well as using displacements with your materials.
In this walkthrough, we guide you through the process of building a polished 3D interior scene inspired by the cover of Archmodels vol. 306 – Table Sets.