I have a decent amount of friends in the GMP as a family member is a local copper and a union rep. They're a close knit bunch.
In my experience with them, the Police are generally socially minded citizens who recognise the difference between right and wrong, and want to help their communities to be safer places. Not all obviously because no ONE description covers every person within a certain group of people, but generally, as a stereotype, it's how they've come across to me.
Hearing that any Police Officer has been assaulted or died is distressing and disappointing, but it's worth pointing out that these are comparatively rare cases and we need to recognise that they're not the norm. I actually had the Police round at my house today because I had to ring 999 due to a violent domestic across the road and they popped in, had a brew, took some evidence then went on their way in a totally professional manner. The offender was restrained and locked up, and they went onto their next job after about seven hundred miles of paperwork.
Extraordinary events are by their nature extra ordinary and it's easy to have a visceral reaction to them. Instead try to take them in their proper context as a freak incident that isn't reflective of the wider day to day job.