Details require contrast to show...and for monotone details that requires shadows and highlights. Generally the best way to bring out a texture (monotone detail) is by lighting it from the side at a shallowan angle.
What the light source is doesn't particularly matter; only that it is primarily directional/hard and not diffused/soft.