Having served 31 years in the Met, the former detective chief inspector has been confronted with harrowing crime scenes that most of us will never face in a lifetime.