Local to me, Arlington and Reston VA have both seen massive building sprees over the past 20ish years (mostly adjacent to the Metro). Home values have never been higher in either location.
My own personal example... I live ~1 mile from the Metro, so just outside the building boom zone. There was next to zero housing in that zone - it was all office parks - and now it's a mix of $1+ million townhomes, $1+ million luxury high-rise condos, and dining/retail. My own home value is up 50% since COVID and that's true for just about any house in my zip code.
And without the redevelopment/infill, I posit the whole area would be less desirable. NIMBYism feels more about "change is bad" than property values.
But Falls Church is much nicer now that a few mid-rise apartment buildings with ground-level retail have gone in! As a resident, I am very happy about all the new development. I expect that over time, that will have a positive effect on property values, but there is an observable short- and medium-term effect working in the opposite direction as the increased housing supply eases demand on the existing housing stock.
I don't know, and I don't believe it's possible to know in a specific instance. Like I said above, I believe that in the long term, denser towns raise the property values of their suburbs by making the area more desirable.
But there is definitely a plausible case that increasing the supply of housing immediately lowers or slows the growth of property values by reducing scarcity. It's the argument made by both sides of the "missing middle" debate in Arlington -- the pro side says it will make housing more affordable, and the con side says it will lower everyone's property values. The article we're commenting on found that at least some version of this is true for the Austin, TX -- increasing housing stock lowered rents, even if the new stock is luxury units.
Also agree it's difficult/impossible to know for a single piece of real estate. And impossible to know for sure since the market is complex (impacted by rates, other policy decisions, etc)
The most overt statement of "we don't want to build more houses because it will decrease the value of existing houses" in recent memory was Trump[1], who is not exactly a reliable source (and whose whole brand prior to politics was destroying the character of established neighborhoods by building giant condo complexes).
[0]: https://papers.ssrn.com/sol3/papers.cfm?abstract_id=5780364 [1]: https://www.msn.com/en-us/money/general/trump-says-the-quiet...
In general I don't think it requires all that much thought in terms of why/how price changes happen. Housing demand is inelastic, and you can find examples of that causing both rapid price increases (metro areas with high friction building requirements) and rapid price decreases (metros with population declines) when out of equilibrium in either direction, which is exactly what you'd expect of a good with inelastic demand.
It's a commons problem. In your scenario, you have absolutely increased the value of your property. 20 apartments is more valuable than a single family home. However, you have also reduced aggregate demand by housing 20 people. That reduced the value of your neighbors' properties (or at least reduced the rate at which their value increased).
NIMBYism posits that values will continue to increase without forcing any property owners to invest in improvements so long as they collectively block any efforts to increase supply.