>a large number of people to come in, pay locals and local taxes, and then leave without using any social services

Sounds like you're describing Downtown SF. I imagine right now many in the city wish the area had been less reliant on people coming in from elsewhere.