I think I'd prefer official, but if there was homebrew as professionally done I'd be down!  

Frostmaiden attracted me because of the ten-towns area.  I'm not familiar with any others.

Official or home brew?

And candlekeep i think comes out in a month or so. Apparently it has over a dozen of smaller adventures

https://www.adventurelookup.com/adventures

Head on over there and search/browse through them looking for something interesting that can fit into your campaign- perhaps with some modification.

Just planning a new campaign and could use some advice!  I'm planning a world with a over-arching quest, but I thought using some adventure modules to fill in the more minor stuff might pad it out.  I've been looking at Rime of the Frostmaiden right now - anything else I should check out for a back drop with side quests?

Best adventure module to embed in my world?