Detective led around 50 investigations into killers, kidnappers and rapists