I guess I consider the Cacowards themselves as the most visible curation of Doom mods online. I'm not aware of anyone repacking sets of mods together for convenient download.
That's kind of a thing in the Bethesda mod communities where installing multiple mods together sometimes requires compatability changes and so a curated mod collection is actually a multi-mod in itself. But most Doom mods tend to be singular things or easily composable.
I use Doom Launcher to manage all my mods and maps and it works very well for that, letting you easily build sets of mods+maps to use together, and it can download files from the idgames archive so that's convenient too.
Otherwise, i dunno, maybe this is a good pitch for a Doom-heavy YouTuber like Mutant Mods or Mr. Icarus? It's extra work for them, but doing a showcase video plus a bundle to get all the mods showcased would make for fun content. I imagine that getting permission from all the authors would be troublesome though.