Tough, but I’m always up for a challenge. Okay, here are some ideas:
Over-the-top campy: the all-time champion for this category is Dead Alive, a film from early in Peter Jackson’s career, way before he did the Lord of the Rings movies. It’s really, really funny. It is, however, extremely gory, so much so that it’ll almost certainly peg your gore-meter. The thing is, the gore is so extreme, so pervasive, so overwhelming, that it rockets past “gross-out” to the point of absurdity. If you can stomach it, you’ll find yourself laughing at how over-the-top it is.
A milder, but still gory, choice would be Evil Dead II. If, however, you can’t take the gore, another good choice is Arachnophobia. If you don’t like spiders, it’ll really make your skin crawl. On the whole, however, the movie is more comedy than thriller. And there’s always Scream, which has a couple of bloody scenes but has a lot of fun pointing out the standard horror cliches, adhering to some and abandoning others.
Scary: This is gonna depend on what scares you in particular. Some people get freaked out by serial killers, or “human horror”, because they fear the real possibility of being killed by a crazy person. A classic that preys on that would be The Texas Chainsaw Massacre. I can already hear you saying, “I said no extreme gore!” Ah, but you see, the truth is that TCM, despite its reputation, is an almost completely bloodless film. There’s only one on-screen killing. All of the horror derives from the atmosphere, which is so well done that it fools you into thinking you’re seeing more than you are. I’m speaking of the original version, by the way; the new version is quite a bit bloodier.
If you’re afraid of ghosts and supernatural beings, The Grudge would be a fine choice, as would The Ring. Avoid the sequels.
If creepy places are your bag, Session 9 would be worth a watch. And one of the movies at the 2006 Horrorfest, The Abandoned, turned out to be a fairly decent movie featuring one freaky farmhouse.
Foreign movies: …hm. Well, Audition did become somewhat well known here in the States, but it seems most people still haven’t seen it. It’s not gory, exactly, but there are a few scenes, such as the ending, which feature torture that’s very uncomfortable to watch. There are the original Japanese versions of The Ring and The Grudge, if you want, although I rather prefer the American version of The Ring, myself. I wasn’t as entranced by The Devil’s Backbone as others have been, but who knows, you may like it.