Please, please, please check out Patrick Stuart's Deep Carbon Observatory:
An ancient dam has burst, flooding the valley below. The landscape is a drowned devastation filled with the desperate homeless and the opportunistically predatory; the lake past the dam is drained, and the things it kept drowned are now exposed, and open ...
I love this adventure, as I love all of Patrick's writings. Its opening is a model for how to run human suffering amid natural disaster in an impactful-but-not-gratuitous way; it has to my estimation the most interesting / nastiest Rival-Adventurer-NPC-Party in all of D&D-esques; I've not seen a better intro adventure to an Underdark campaign, yet.
Throwing in another vote for Emmy Allen's Garden of Ynn -- an adventure set in an extra-dimensional garden / maze, done via tons and tons and tons of random tables.
Also for Dead Planet, by Sean McCoy, Donn Stroud, and Fiona Geist -- *the* cutting edge in terms of layout and information design for adventures.
I'd cite Jacob Hurst's Hot Springs Island -- another masterclass in information design. A complete hexcrawl bursting with stuff, but a breeze to read and refer to because it is written and laid out to be usable first and foremost.
Luke Gearing's Fever Swamp -- hexcrawl set in a swamp. This is the kind of adventure I want to make when I grow up. Crazy, how much stuff it gets done in, what, two-and-a-half dozen pages?
Jason Sholtis's Operation Unfathomable -- just fucking fun. Underdark adventure. Pulpy goodness, doesn't take itself seriously, full of stuff for players to prod and pick at.