I figure this is as good as any spot to pose this. Anyways:
In the coming weeks I will be starting up a campaign, with myself as the DM, and I am at present lacking modules to work from.
Having gathered input from the individuals that will be in the party (which regretfully will consist of two players and a third character run by myself till we get more later on), and rather consistently they have stated they want this campaign to be horror oriented and for it to have strong elements of the occult. I've some plans and rough notes on a personal setting, and a general arch concerning the gods gradually growing more silent. Additionally, and perhaps more importantly, I already have materials for the first session, starting them off at level 0 with some basic material derived from/inspired by the AD&D module Treasure Hunt, and they are in line to reach 1st level and still be at sea. I wanted them to start with characters and develop them first before we throw elements of classes in, and they are perfectly fine with starting without class levels.
That having been said, I don't know which modules to go for. I don't know how long this campaign will run, nor do I know if I'll get to play out everything I want to, but I'll tweak things as needed.
The bottom line to all this is of course the question; What modules would you recommend I get to satisfy my horror-craving party?
Some modules that have the reputation of a "horror" feel:
Feast of Ravenmoor
Carnival of Tears
Carrion Hill
The Midnight Mirror
The House on Hook Street
Hangman's Noose
Note that Hangman's Noose and Carnival of Tears predate Pathfinder and were written for 3.5 rules.
In addition to the fine suggestions above, the second part of RotRL and the first two parts of Carrion Crown can be used with a little work to strip out the campaign trappings.
Hangman's Noose is excellent, but only works as the starting point of a campaign, since it pretty much requires your PCs to not know each other. So it's probably out if you want to start a different way, although it does have a fairly occult feel to it.
From Shore to Sea would work well, and fits the coastal flavor that you'll get by starting your party out at sea. More Lovecraftian than occult, though.
There's likely a few good PFS scenarios too. I don't know that many, but Black Waters (from season 0, so needs converting to Pathfinder rules) is frequently mentioned.
I'll recommend a couple of my own which are currently on sale.
Dance Macabre (http://paizo.com/products/btpy99xg?Dance-Macabre) is more macabre than horror.
Reign of Terror (http://paizo.com/products/btpy9g47?The-Reign-of-Terror) is proper horror (IMVHO).
Each has some reviews for you to look at too and they also have free previews.
Richard
