Whilst a fan ofThe Green Mile and Blade Runner, I prefer The Shawshank Redemption (another Stephen King adaptation) which is certainly one one of my top ones and whilst it was not a great success in the cinema at the time became a fave after the video/DVD releases.
I will also mention A Beautiful Mind, Lord of The Rings (Return of The King) ,The Matrix and The Exorcist, though quite a few I enjoy.
There's quite a few films I like. (Some of which are quite good too. )
But for sheer personal experience:
Lord of The Rings: Fellowship of The Ring (Theatrical Version) - As a massive Tolkien fan, I love the Extended Version's additional Tolkien geekery. But when I saw it in the cinema, the Theatrical Version completely blew me and my scepticism away; had a perfect pace and flow; made me forget that I know the story backwards; and had me falling in love with that story all over again.
Honorable mentions to both The Matrix and the 1986 animated Transformers movie (the first movie I saw in the cinema) too; both of which had me completely spellbound when I first saw them on the big screen.