You know what, you're right: "disturbing" is a far more accurate word to describe my reaction to Irreversible and Requiem for a Dream than "depressing." And, no, the end of Requiem isn't particularly believable, but neither is Hamlet, and I don't see people holding that against it.
