Where do you find these?
Textured coatings were used to produce decorative finishes on ceilings and walls. In the past, they have had various trade names such as 'Artex'.
What do these look like?
This is dependent on the particular decorative finish required ie peaks or patterns. They are hard and were originally white in colour but have often been painted over.