There are people who read Tolstoy or Dostoevski who do not insist that their endings be happy or pleasant or, at least, not be depressing. But if you're writing mysteries - oh, no, you can't have an ending like that. It must be tidy.
Most people see what they want to, or at least what they expect to.