In the old days, the rule of thumb was that upgrades (vs renovations) did not increase the sale price – just made you house stand out from all the rest (wherein lies the value)
I’ve always gotten a kick out of “professional” appraisals because it has always really just been a matter of sq ft more than anything else – now what was done with the sq ft is what will make one house more attractive than another but not necessairly increse the sale price.