A senior police officer who oversaw a drive to 'write off' thousands of minor crimes has lost out on a top job in England - and is heading back to Police Scotland.