It's absolute insanity
Large sales tax on home purchases is probably a generally bad idea. Looks like Bay Area pricing would incur a 10-12% tax under the UK scheme which seems pretty crazy.
Likewise if I buy somewhere cheap in a backwater town, and the town becomes more desirable because there are better employment opportunities, better shops, better amenities, all of which serve to mean people will pay more for the land, then I benefit from that immediately.
Most people’s home values go up because of 1) increasing housing demand and 2) the collective delusion that home prices can continue to far outpace wage growth indefinitely. Neither of these things necessarily result in an increase in amenities or improved quality of life.
My own home value has gone up something like 70% in the last 10 years. Meanwhile, the amenities near me are essentially unchanged. Same schools. Same number and quality of restaurants and grocery stores. My net worth has jumped a fair bit but my immediate benefit seems pretty much flat.