Import geometry into COPs, extract the normal map using a Rasterise Geometry node. Then you can either paint on it or distort it using a noise map or a brush strokes texture. Then apply it to you shader.
I'm making a new tweet to explain how to solve the faceting issue.