Well, that's how it should work. Qualified immunity massively complicates this in favor of the cop and therefore the city employing said cop and the residents of the city. It is technically not impossible to win such a case if you get a court to take it, but you might be facing some insurmountable odds getting a court to take the case.