This is an example of a quick tileable texture I created from scratch in ZBrush. It consists of 2 different stone subtools that were rotated, angled, and scaled differently. As far as my approach to creating the diffuse map I laid out a base colors on the subtool, and highlighted the edges using the Trim Dynamic brush, then modified the MatCap on every other tool I dropped. The rest of the texture work was done in Photoshop.
The following images are different view modes to show how the tiled material is affected by light.
Note: Only the assets being affected by the different view modes are mine, the rest are udk assets.