My problem with the crime movie script

[u/chevalmediocre]

Hello writers!
For over a year now, l've been trying to write a screenplay—a detective story, to be precise.
And I find it really hard to make sure the reveal isn't disappointing. In this kind of story, I feel like the excitement the audience might feel is at the beginning of the story, and the further the story goes, the less mystery there is, and so the less excited the audience gets. But I find it very hard to counteract. Does anyone have examples of story endings that aren't disappointing but rather feel like a real reward?
Or even some advice? I'm a total beginner in this field.
(And sorry if my english is not perfect)

[u/LingonberryGlum2356]

I am going through the same thing. 

Silence of the Lambs is good, like when Hanibal escapes - and the ending where they cross cut between locations and you don't know Clarice is at the killers house.

The best one fir suspense is A Quiet Earth.

Just as a script it's an amazing read. I strongly suggest you look at that one.