I’m working with 2 directors who are using the first movement of Beethoven’s Moonlight Sonata in their films. Never a bad choice. The piece is cinematic in the extreme, even though it was written a hundred years before film was invented.The BIG moment in Misery uses it. Certainly because the Moonlight Sonata is expressing something deep about romance and obsession. The scene unfortunately adds a layer of strings to the melody, but that seems not to detract from the, er, impact of the scene.
(This is NSFW, only because if you haven’t seen it before, you will likely shout quite loudly when the big moment, um, hits…):