how to make a horror material for a wall?

Take a look at Substance Designer and Filter Forge, they are great for creating tiling, customizable, game ready textures.