Paco Pascal Nader, also known as Pacoco, knows how to make boring textures shine and is willing to share his tips. In a thread on X/Twitter, he included some hand-painting tips you can use on your textures, stylized or otherwise.
He recommends thinking about the depth of the object and its story: how did this wear and tear appear? What happened after? Also, you should consider logic and appeal to make textures that attract attention.
Oh, and play with colors – make them your own!