Most people assume paint is paint—but using the wrong one in the wrong place can lead to faded walls, flaking