Are there any real examples of this actually happening?
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.
Yeah, I live in Falls Church, which has seen more build-up than other areas in Northern Virginia because the city has never had the kind of restrictive zoning that the anti-"Missing Middle" campaign is still fighting in Arlington. The value of my single-family home peaked in 2024 and has dropped slightly since. To my understanding, this is generally true of my zip code and not true of comparable zip codes in the area.
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.
Literally the entire peninsula of the bay area is an example of this happening. You have people voting to "keep their small town feel" sandwiched between San Francisco and San Jose.