I really like the Inspector Banks novels by Peter Robinson. Here is a detective who has a life and family that actual effect his work like a real person. Imagine a detective's horror at investigating the murder of a girl the same age and appearance as your daughter. Well Peter Robinson can and includes this in one of the books. A very nice addition to the traditional detective who's job and life never interact.
The URL to learn more is
http://www.inspectorbanks.com/
Enjoy the read!