I don't have a specific example of what the final scene should look like. I’m creating a modular Japanese school environment in a stylized, minimalist anime style. The design is intentionally kept versatile, based on my own concept and preferences, and once I’m done with the wall, I’ll work on creating the fountain in the…
As for stylized textures, you could search around on the forum here, lots of resources on how to paint textures, for example https://polycount.com/discussion/117119/a-pack-of-textures-painted-using-hand A fairly common strategy (and quite successful) is to use Substance 3D Designer to craft a height map, then alter that to…