Alexey Kashpersky has a walkthrough of a beautiful picture called “Dream” that he created using ZBrush, Photoshop, and several plugins like Ornatrix. Rendered in both v-ray and MentalRay and composited afterwards, it’s a fantastic image.
Although, it may be slightly NSFW, some artistic female nudity.