This is based on opinion. Please don't list it on a work's trope example list.
Nightmare Fuel / The Village
Whatever your opinions of the story as a whole, there is little doubt that the scene where the bell starts ringing and a trio of figures in red cloaks walk out of the woods is utterly hair-raising.
One moment in particular from that scene; Ivy, standing in the doorway of her home, hand outstretched, waiting for Lucius to return, ignoring both the others' pleas to barricade the door and the threat of the creatures. The camera shot focuses on her outstretched hand from the left side of the screen, and you're just waiting for one of the creatures to grab her from the right. Finally, Lucius comes in from the right, but just before that, we see a clawed hand, out of focus, reaching from straight ahead...
Being blind and lost in the woods you believe/know are filled with monsters wanting to kill you, and your only defense is a huge, unweildy log/flimsy wooden stick can not be comforting...
Noah's death at the end of the movie. Impaled with Extreme Prejudice at the bottom of a pit, and since he's autistic, he probably has no idea why this is even happening. And it more than likely took him a long time to die as well.