In the past 12 years there only was one time where I even witnessed tension between us and them (an elevator emergency with victims, where ESU (New York's SWAT equivalent) and FDNY had overlapping jurisdictions). The bench-clearing hockey game brawls are the stuff of TV.
Cops are by and large professionals, who get shot in the face while protecting the same community that vilifies them for a few bad apples.