At medium distance the texture looks good, at long distance the texture is not so good and in short distance the texture is horrible and distorted.
You can argue that is the texture, well take a huge and with excellent quality texture. When you render it the result is better, but still is bad at short distance.

The problem with photo-based textures is that they are comprised of pixels. This is not the fault of the CG camera.

If you looked at a digital photo very closely with the human eye, quality would still erode.

Download my free stuff here: http://www.renderosity.com/homepage.php?page=2&userid=323368