I would prefer the cops not have any guns at all. They would certainly be more polite. If they are going to go do something that would need a gun they need a warrant and then 5 pages of requisition forms filled out in triplicate to request the guns.

Not commenting on the other parts of this discussion but a single shot from a rifle absolutely CAN cause permanent hearing damage. Even some weapons suppressed are still loud enough to damage your hearing over a short amount of time/multiple shoots. Have you ever seen or watched news of cops shooting someone and NOT firing multiple rounds?
Of all the tactical battle rattle these ICE dorks are wearing to capture people, I think suppressors are the least worrisome; should maybe even be mandatory for law enforcement in urban environments. That's coming from my experience shooting in the Marines and being a hobby shooter since then.

It's not like they've been trained in any de-escalation techniques, if they've been trained at all.

A suppressor on a subsonic .22 caliber gun is about as close to movie/video game quiet as you can expect. There is still variation, but subsonic ammo eliminates the "crack" from the sonic boom (comes from the bullet itself), and the suppressor reduces the muzzle noise a lot. In person I've heard one suppressed subsonic .22, and it was about the level of a good clap. 👏

A good answer to your question needs more specifics, but in general, suppressed handguns with home-defense or target ammo are still loud enough to gain attention.

On the other hand, subsonic ammo will be pretty quiet and reduce the noise drastically, but unless you have the semi-auto mechanics tuned properly, the gun won't cycle the next round in very well. I can't speak to the stopping power of subsonic ammo but again, it probably requires specifics to give an accurate answer.