The problem is that most places don't have the funds to run a completely separate dedicated SWAT. So what they do is place a bunch of regular cops on it, so that they end up sharing their time between SWAT training and door-busting, and regular policing. Needless to say, it doesn't go well, because SWAT training and practice instills the kind of us-vs-them "warzone" mentality that is extremely detrimental to day-to-day policing.
The other problem is that once SWAT is there, cities start using it everywhere on the basis that they have already paid a lot for it, and might as well get their money's worth. This is encouraged from below (i.e. by the officers) too, because raids are more "fun", but also because civil asset forfeiture proceeds from a well-timed raid can be immense, and goes towards the police budget - from which they can buy more SWAT toys like APCs, battering rams or .50 BMG rifles... which then become things begging for an excuse to use, and so the cycle closes.
I would hope that if the local police force has decided to not budget in a response team of that nature then likely they don't need one. But, if they needed one and don't have the budget, then that's a different problem.
Surely there are special forces to deal with that sort of situation? I know there are in the UK.