Home improvement is costly, but it pays in the end. CNBC looks at the kinds that have the best returns and value.