Or how to lazyly do handpainted texture from a photography. The answer is Photoshop, xNormal addon and a sh*t-tons of effects (blur mostly) and blending. It was a time killer when I didn't have anything to work on. Some are not good looking, some are really nice. They have normal map & height map.
You can get them on Gumroad : https://gumroad.com/l/lUaQO