In terms of horror that's not scary, more exciting/compelling, I'd pick Silence of the Lambs
. Totally brilliant movie in so many ways. Aliens
falls into a similar category. I could reel off a pretty long list of those sort of movies that I like.
I don't like scary movies that are just scary though; you know, the ones designed just to keep you startled. I tend to avoid watching those sorts of movie.