I'll second the Ship of Horrors recommendation - it's a nice, atmospheric, spooky adventure... I'll also second the original Ravenloft suggestion (or third, or fourth it). It's a classic, and one of the first to ever veer out from the simple dungeon crawl/linear quest paradigm.