As a photographer in the USAF (both as military and civilian), I got to work with the Air Force Office of Special Investigations (AFOSI) or just OSI, quite a bit. Crime scenes, fraud, waste and abuse cases, and other odd things where they needed photographic support.
Did some boring stuff with them, some occasional funny things with them, a lot of fascinating things with them and some ugly things or even; really ugly things.
Many more times than not, their professionalism was extremely high. I have heard of a few times over the years where they dropped the ball on a case but I never saw it. And, it wouldn't be a perfect process if humans were involved.
Some days I think it would be great to be called up in the middle of the night one more time and requested to show up at the scene and ask once again, "Whatcha got?"