It is common for people to buy up land just for the water rights, then transfer that water rights to other property. So if you search for land in Colorado it isn't unusually to find one plot of land in the millions and then another one a few miles away that is almost free in comparison. This is often due to the water rights associated with that property. The expensive land can be used commercially for things like farming, the other cannot.
And there have been cases of governments using tax money to buy up property just so they can use the water rights to help out private ventures, like building suburbs or golf courses without the knowledge or consent of tax payers.
Also it is pretty normal anywhere in the country that local governments react poorly from aggressive demands from people, especially when they are not voters.
All in all it is a nasty business and making sure you know exactly where your water is coming from, how you are going to pay for it, and what your rights are to it, and what you are allowed to use it for all need to be factored in heavily when moving out to the desert there.
As far as I know there is no way to sell the right away to drill an 'exempt' well. I hope CO looks into something similar.
Caveat that there are very different factors in play in more populated areas.
As a thankfully-former Florida resident, there's also a current of hitherto politically unengaged (and still democratically uneducated) citizens showing up at meetings and deciding that if they yell the loudest they should get their way.
Some of the shit grown-ass adults did at Florida school board meetings was just mind-blowingly ignorant.
It also made me realize how low the bar of civic education is in the US.
Real democratic change comes from organizing, coalition building, compromise, and engagement with stakeholders. Not knee-jerk emotional outbursts.