Adventure writers I've enjoyed include
Kelsey Dionne (Arcane Library),
M.T. Black,
Jeremy Forbing, and
Will Doyle. Each of them have stuff on DMs Guild / Drivethrurpg as well as their own sites.
Kelsey is great at terse prose that gets to the point. I find her stuff very accessible (from a time-harried GM standpoint) in a way not many adventure writers accomplish.
M.T. Black is really good at holding the big concept of the adventure, being able to focus and follow through on that, without getting distracted by stuff that doesn't reinforce that concept.
Jeremy has some really ambitious work, the Masque of the Red Death stands out, and his adventures are wonderfully evocative and creative.
Will Doyle is one of the more innovative adventure designers I've encountered. He's known for his blend of beautiful cartography & writing, but he's also taking risks and doing things I haven't seen done in adventures before. I need to find more of Will's recent material (e.g. I know he worked on the Tomb of Annihilation team), but his 4th edition
Tears of the Crocodile God (online post-Paizo
Dungeon #209) was truly a stroke of genius with how the "sacrifice victims" & "big bad" move through the dungeon. Would be a great adventure to update to 5e.
Another good one was
Cat & Mouse (Richard Pett & Greg Marks; Kobold Press), which is a solid introductory adventure in an atmospheric city. Nothing really innovative, just a very well done classic feeling urban adventure. IIRC it was converted from 3e.
Speaking of Kobold Press, I would love to try out
Wrath of the River King (Wolfgang Baur & Robert Fairbanks), which has a very evocative fey theme. The discontinued "
Warlock Adventures" vignettes/locations were also good from the ones I looked at (e.g.
WL 16 - Lammasu's Secret). Again, nothing that you couldn't do yourself, but very solid concise clear locations built around monsters from the
Tome of Beasts.
Mike Shea's
Fantastic Locations fits a kind of similar niche as the "Warlock Adventuress", just more fleshed out and with better art/layout to match the higher price point of the compilation.