Affliction (1997)

Boston University professor Whitehouse tells of the events leading up to the disappearance of his older brother Wade. The police officer who investigates is deeply troubled, and the murder case drains his mental acuity to the point of a total mental collapse.