While there is a main plot, the "Scourge of the Sword Coast" follow-up allows for significant player agency.
A deep dive into elemental nodes and the machinations of the Red Wizards.
It retains a dangerous, "deadly" vibe often missing from more modern, heroic-focused modules.