My favorite short adventures are the Journeys through the Radiant Citadel anthology. My other favorite go to is Arcane Library adventures. I've also liked a couple of Keys from the Golden Vault and Candlekeep Mysteries, although I've only read a couple adventures from each.
My honorable mention goes to The Great Modron March anthology of adventures, which is from 2e but can be converted to 5e relatively easily.