Painting is one of the easiest, most popular ways to give a home a DIY update. But is that always the right answer?