Before the days of Scotty's list, I used to refer to the Wiki for "User Made Campaigns." That's truthfully where a proper list of campaigns should be, though maintaining that is certainly more of a challenge than in a stickied thread. Obviously, a proper wiki directory and dedicated page for a campaign is much better for giving you an idea of what you want to play, or even what you do not want to play.
...The problem is that many of the campaign pages are not up to date, and if they have links to files or data, those links or data may also not be up to date.