anyone here spoken with a detective, starting to think they only exist on tv

Unless you commit or are a victim of a crime worth investigation (Kidnapping, Homicide, Armed Robbery, etc.) you'll never see them.