i heard that new justin beiber movie was pretty scary.
anyways, if you're looking for recent horror, insidious is okay [warning it gets dumber as it goes on], but the music is pretty stellar, which i think can make a movie nice and creepy. spain has been pumping out really good scary movies, if you haven't seen the orphanage (el orfanto), might be a good one to go with. you could try REC as well.
i think how scary a movie is really depends on the person. of course you're not gonna get scared if you don't turn out the lights or if you sit there talking or laughing the whole time. pet peeve of mine.