Amazing!
Texture + normal +... maps - auto gend!!
CrazyBump:
http://www.crazybump.com/
Tutorial:
http://www.blenderguru.com/videos/the-secrets-of-realistic-texturing/
Free alternative:
http://blenderartists.org/forum/showthread.php?317041-Insane-Bump-2-0-overhauled-Crazy-bump-alternative