Mania: The Last Exorcism provides a textbook example of fumbling the ball on the goal line. For 100 minutes, it offers an eerie, thought-provoking exercise in faith and fear, vacillating back and forth between rational science and deepest superstition.