I thought I would chime in -- mostly echoing what others have said, but with a few of my own selections. To avoid appearances of favoritism, I'll list this in alphabetical order by author.
Also, I've got links.
(contact)'s
Return to the Temple of Elemental Evil -- note that this is not the original, original thread; rather, it's a reposting of it
(contact)'s
Liberation of Tenh -- a follow-on to the above story, with some of the same characters
(contact)'s
The Risen Goddess -- less well known that the other two, this is the most philosophical of the three stories. It begins: "Four adventurers sit around a familiar table in a familiar inn, not too far from a place they must have surely known their whole lives-- if they could only remember any of it."
barsoomcore's
Barsoom story -- very well written. You won't know what the hell is going on half the time, but you won't be able to stop reading despite that.
Capellan's
Company of the Random Encounter -- don't let the name of the story fool you; this is worth reading
Capellan's
In Hextor's Name -- to paraphrase the author, the story hour is "written from the limited and very, very biased point of view of Kull Redfist, LN Half-Orc Cleric of Hextor, Life's ambition: to become a mighty warrior and crush Hextor's enemies."
Destan's
Sins of our Fathers and
Sins of our Fathers II -- grim, gritty, and utterly compelling, with a definite old school feel to it.
James McMurray's
Return to the Tomb of Horrors -- you know about the original ToH, you know about the Return, but you do not know the pleasure of this story hour's approach to it. This is the story hour that made me appreciate high-level play.
Rel's
Faded Glory -- proving that pitting the PCs against challenges 4+ ELs above their level makes for a great game.
Rune's
Oriental Adventures in the Dream -- the most mind-blowingly original campaign setting I have ever seen... "The world: Ah yes, the world... It is flat, but not really. There is no sun; there are no stars, nor moons. Day and night do exist, however. There is seasonal change (how could we have haiku without it?), but that change is sporadic."
Sagiro's Story Hour -- epic in scope, with a large cast of characters. It took me a while to get into this story, but once I did, I was hooked. You will be too.
Sepulchrave's
Tales of Wyre, or, Lady Despina's Virtue -- you cannot beat this opening: "One of the PCs, a 14th level Paladin, [...] is currently attempting to CONVERT a succubus, and demonstrate to her the error of her ways."
spyscribe's
Welcome to the Halmae -- the aptly named author of this tale keeps it constantly updated, unlike some of those OTHER authors. The campaign starts out small, but grows rapidly into a grand series of quests. Read this story because... justice demands it.
Wulf's Story Hour -- follow the adventures of Wulf Ratbane, dwarven bad-ass. Or would that be bad-axe? In any case, one of the strongest archetypal characters of any story hour on the boards.
For a second opinion, check out
this thread or
this one.