The opinions here are probably influenced by Prop 13 in California and by the fact that many younger people in the tech field capable of buying property probably assume that they'll be selling and moving somewhere else sooner rather than later.

But, as you say, someone who plans to remain in their house indefinitely would probably just as soon not have their property taxes double (and may not even be able to afford them in they're retired on a fixed income).