Although, of course, the opening narration spoils it. Which is why friends don’t let friends watching Dark City for the first time hear that narration; keep it on mute until you see the bathtub, folks.
/PSA
Heh. I do that too.
Sixth Sense
Usual Suspects
The Crying Game
There is a very nice director’s cut DVD that has the silence in the beginning. It’s worth it.
That’s a good one. Unless you do like I did, and play the audio version for someone who hasn’t READ Sherlock Holmes. :smack:
Definitely! Children of the Lens was a great example of how to end a long-running series. Though I wish he would have put more about Cynthia in it. 
I thought Clarke’s Childhood’s End worked pretty well, too.
Fight Club
*The Greek Coffin Mystery *and *The Egyptian Cross Mystery *by Ellery Queen. IMO, the first of these is as radical as The Murder of Roger Ackroyd and the second is a brilliant piece of misdirection. If you ask yourself the right question in the first 30 pages, it’s obvious who the murderer is, but I’m betting most of you are like me: you didn’t ask that question of yourself.
*The Long Goodbye *by Raymond Chandler The scene where Philip Marlowe fingers the murderer is probably not as surprising as some other mysteries, but the way Chandler wrote it made it very powerful.
For science fiction, I’ve always thought Arthur C. Clarke’s *The City and the Stars *was pretty mind-blowing.
Could you put it in a spoiler box please? Having just read a few of Lovecrafts short-stories I’m intruiged.
From Watchmen:
“It’s Adrian.”
Angel Heart
Well, it follows the story as far as I remember, but
there’s a King Kong-style stop motion Chthulu at the end that ought to suck but IMHO was AWESOME. There’s two big set pieces in the movie - the Louisiana cult and the ship with the island, and both have this wonderful dreamlike quality.
The scenes where people are sitting and talking to each other are amateurish. The scenes where stuff happens are fantastic.
ETA - and somebody obviously shares my nitpick rage about bad fake old newspaper clippings in movies - the ones in this one are perfect.
You broke rule #1! 
Came here to post this. Awesome and creepy.
The Murders in the Rue Morgue is a classic.
Some consider it to be among the first detective stories.
In Children of Men the mystery isn’t very hard for the audience to figure out, but the two scenes where the characters become aware of it* are awesome in the original sense of the word – everyone is struck dumb with almost religious awe.
*Spoilered:
When “the girl” is examined and again in the famous scene when everybody stops shooting.
And #2!
A lot of these (Oldboy, Chinatown, Usual Suspects) of these don’t seem like mysteries that are revealed, but rather unsuspected twist endings. To me, the mystery of **The Matrix **is how & why the machines came to power, which isn’t revealed until the sequels (and isn’t a good reveal). Likewise, the mystery of Children of Men is why were children never being born, which is never explained.
Awww, man, my library system doesn’t have it. Is it worth ordering on Amazon?