The Madness at Gardmore Abbey is precisely what you describe (old school location with potential, without merely being a sandbox).
The con adventure for PAX, The Siege of Gardmore Abbey, is the opposite (character, plot, and story based).
Though related, each takes a different approach to D&D...