Given that Hallowe'en is just around the corner..
Not really scary but visually well done I'd recommend Nightwatch and Daywatch. These Russian films (with the wildest subtitles I've ever seen) are really well done and have a flavour that seems similar to Resident Evil with some dark humour thrown in.
For horror/scary, lately I did finally check out some of the Saw movies. Seriously, however, after the first couple the point was made. I started watching VII but couldn't finish it. We did finally check out Jaws. Now that is some good scary stuff there! It's all about the mind-mess, IMO.