I see it used mostly for manually painted 3D scenes - where the artist has textured the objects with brush strokes, or a procedural shader setup that makes it look like they've been painted.
Random example from the internet:
I see it used mostly for manually painted 3D scenes - where the artist has textured the objects with brush strokes, or a procedural shader setup that makes it look like they've been painted.
Random example from the internet: