my guess is that he wont be able to blend in and get another job when he is fired...the liability issues in a law suit for any police station who hires him is to big. 10 years ago I would say you were right about the guy just moving to another city and getting hired would of happen but to day because of information being so readily available you cant hide from your mistakes they will fallow you.
The solution is to remove LEO immunity to civil suit.and require, as a condition of employment, that LEOs must purchase malpractice insurance. If they cost the insurer more than the actuaries deem reasonable, they will be unemployable in law enforcement.
Eliminate their immunity from civil action, just as doctors have to carry malpractice insurance, police officers should be required to carry professional liability insurance as a condition of employment. Can’t find an insurance compny willing to insure you...find another line of work.