It's old, and would need a little updating, but it rules. Castle Amber. If your players go to sleep, you've got all the hook you need :). It's got all kinds of opportunities for subplots, it's got action, comedy, it's fun for the whole party. And kinda on the lower level side of things, but...