It is also possible to do big, expensive, necessary renovations on a house and have it hardly affect the value at all.

Isn’t this kind of irrelevant unless you’re a house flipper? If you own a house and make renovations to it, it is because you find some practical value in it.