You want to blend tiled clean materials with some distressed materials through mix and composite nodes. Ideally you should also drive blending with geometry dependent nodes, like Corona AO, curvature, distance etc. Alternatively you can author your materials in programs like Substance Painter, or Designer, but that would require to output very high resolution final textures, which might not be ideal in terms of memory usage.