The question was "what do you expect". I expect police to uphold their oath to the Constitution and the protections it affords citizens.
Good luck with that. The fact is that crime infested ghettos aren't going to attract the kind of cop you're looking for. They're off policing other cities. So you have a choice between low level cops who join the force to bust heads, low level cops who can't do any better, or no cops at all.
Monello and I talk about this all the time in our travels. Choices. You can be a cop in Paterson, NJ OR you can be a cop in Ogunquit, ME. Which do you suppose anyone worth a #### will choose?
Now, you may go with "no cops at all" and there's a case to be made for that; in fact it's the choice I'd go with. But society has decided that police must have a presence in the worst #### hole drug ghettos. And guess what? Andy Taylor isn't applying for that job - he's off in Mayberry where he can have a nice life for his family. Any Baltimore or NYC or St. Louis cop will tell you that they're spinning their wheels and just trying to survive to retirement. They know they can't make a dent in the crime and degradation of those cities. They can make little differences here and there, but by and large it's a soul-draining job.
And another thing: cities with bad cops happen because the city (and sometime state) government isn't any better. They're not in office to make their cities better and improve the lives of their citizens; they are there because it's easy pickins and they can get rich and powerful in their little fiefdom. All these bad cop stories you post have a common theme: they happen in #### hole ghetto cities that no decent person wants to live in. And if you walk it up the food chain from the cop to the police commissioner to the city council to the Mayor, and even further, what you're going to see is a big ball of corruption and cronyism and general lack of interest in anything other than power and money.
So I stand with, "What do you expect?"