I'll second Apt Pupil. I am one of the few (at least according to what people wrote in the other thread) who liked the story, but I thought the film left a lot to be desired. The casting was well-done, the script and the direction not so much.
I'll also one-up the 1997 mini-series version of The Shining. That thing was awful.