Cities have their own sales tax. And so can school districts (and they can have their own property taxes, too).
And sure, you're right, there's not much housing under $1M in the Bay Area. That doesn't change the fact that a $1M home in TX still pays about the same in property taxes as a $2M home in SF. Or the fact that in SF your property taxes are essentially frozen at purchase price, and in TX they will increase every year.