It's hard to write a good story-heavy adventure for a group (players and characters) that you don't know. This includes every adventure written for the market.
There will inevitably either be a lot of railroading or a lot of dungeons (which is a form of railroad itself).
The only true...