What are detectives really like?

Wouldn't it be fun to get to follow a real-life detective (police or private) for a while and find out what he really does? I am sure it is considerably different from what we hear on old radio shows.