Comedy where Main character is a guy that sees dead people. Guy is a private detective that solves organized crime happening in a small town. Movie title is the characters name

Following an unexpected tragedy, child psychologist Malcolm Crowe meets a nine year old boy named Cole Sear, who is hiding a dark secret.

Dr. Michael Rhodes, a professor of parapsychology who, along with his assistant Nancy Murphy, attempts to solve supernatural mysteries.