So, anecdote on Community Resource Officers. My high school had one. And I liked the guy, he did do a lot of out reach and stuff.
But one time there was a fight in the atrium during a passing period, and dude just runs up and pepper sprays everywhere. It spread all over into the upper floors and pretty much everyone was in class with tears and coughing.
I kind of think when they have so little to do, they over reach when a small thing happens.