^^
While you are correct in saying that the market will usually settle these debates, I’m not sure the market will - or even should - perform the way you predict.
Firstly, I’m not convinced that RC’s necessarily result in lower property values and if they did I would think anyone supporting “more affordable housing stock” would support that rather than oppose it.
Secondly, I’m not sure you need “100% buy-in and complete control over an entire modern neighborhood” for RC’s to be effective. You only need enough contiguous lots on any given street within any neighborhood for them to be effective in preserving the character and makeup of those streets.
Thirdly, your “messy patchwork of rules” is not really any different or any more problematic if it incorporates some RC’s than what we already have with our zoning bylaws that provide exemptions or different rules for TOD sites or historically designated buildings or direct control sites or even temporary parking lots for that matter.
Lastly, as for my property rights being potentially “frozen in amber” and potentially its value along with that (although the market as you noted will determine if that or the opposite of that actually takes place in the future) there are some things that are more important in life and life styles than others and I’m perfectly okay with that.