If the police themselves are corrupt and abuse their power, that's a problem, but it's a separate problem that not every country faces. If I was an American, I'd want to have proper accountability for the police first. They should be held to a higher standard than ordinary people, not a lower standard, like it seems they are.
Also, I think the chance of the police (as a group) not being corrupt is about the same as politicians (as a group) not being corrupt - essentially zero. The incentives just aren't there for there to be no corruption in law enforcement. And even if there's no corruption in law enforcement and your government is great, you still have to remember that police officers generally aren't the cream of the crop of society. They make mistakes and there usually isn't much recourse.
In a round about way, the argument ends up concluding that we are, in fact, on some version of a slippery slope. We can see that slope quite clearly in what you write:
"So many petty crimes (e.g. home burglaries, car breakins, etc) go unsolved because the police just don't have the tools and resources to go after all those crimes."
Even just ten years ago, a number of the ideas being batted around now about privacy would have seemed alien. I understand that attitudes can change, but do we have the right attitudes now? Are they good attitudes? The attitude that sees nothing wrong with seriously contemplating whether it's a net good to have the police sitting in a tiny camera outside your front door? Go back a couple decades and we would have been appalled at the notion.
Sometimes I surprise myself with how much ground I've given up already (even if just on a personal level).