DMs Guild content, IMO, is often inferior to D&D content on DriveThruRPG.I share your same concern regarding DM's guild. My experience is pretty limited, but the little I have seen was quite... pedestrian. I can come up with a better adventure with little effort. Perhaps I had bad luck?
Being on DMs Guild just lets you say "Elminster" and use carrion crawlers. It also takes a bigger cut of proceeds than DTRPG does (well, WotC takes its cut, which is effectively the same thing), so most of the pros prefer DTRPG or their own third party stores.
But if you're looking for good adventures at either site, I recommend either looking at works by @M.T. Black or The Arcane Library. (The latter are extremely streamlined, so not heavy on lore, but are designed to be able to run with zero preparation, coming to the adventure cold. They're really a marvel of presentation.)