I really enjoyed the Mothman Prophecies (only watched it recently) because you were really never sure if the Characters involved weren't suffering from some sort of mental illness, or if things were just an unfortunate series of events. It also has a bunch of trippy visual effects in there that don't appear to be CGI.

My friend and I had a completely different interpretations of what happened in the final act. Well worth watching the movie.