I know the Barcelona case closely, in basic numbers: A tourist in a tourist apartment pays €9.50 per night, of that, only €1.13 (11.8%) goes to public housing, the other €8.37 disappears into tourism promotion, general budgets, and municipal projects.
Meanwhile, the local keeps paying their property tax and rent without getting anything back... the tax doesn't reduce their taxes, it just collects more.
I know the Barcelona case closely, in basic numbers: A tourist in a tourist apartment pays €9.50 per night, of that, only €1.13 (11.8%) goes to public housing, the other €8.37 disappears into tourism promotion, general budgets, and municipal projects.
Meanwhile, the local keeps paying their property tax and rent without getting anything back... the tax doesn't reduce their taxes, it just collects more.