Silly idea, but maybe we could invent some kind of LOD system and combine procedural techniques with hand -painted textures.
Like hand-painting a seamless texture, making it into a 3D texture and then scaling it according to the Camera distance, something like this:
