Home renovations can significantly enhance the value and appeal of your property, but not all projects offer the same return on investment.