Just saw a video of Quixel. They made a silent hill room:
And they use decals to provide a more detailed environment. I think this is a very powerfull way to add more detail on walls and object without going in to a complex material setup.
Is there a way to do this in blender?