The recent Garry's Mod situation has made me realise that Steam Workshop kinda sucks as a system. It's more convenient, yes, but giving the game's publisher responsibility over moderating mods makes DMCAs significantly more likely as the workshop could be considered part of the game or its marketing in a sense - plus, legal woes aside, troubleshooting is a lot harder if you're not adding the mods directly yourself and don't know where they go, (I've modded a lot of games, and Rivals is easily the single one I've had the most issues with, particularly when it comes to figuring out which installs are causing problems) and Workshop makes it really hard to go through mods and uninstall them.
In fact, I'd say mod sites as a whole are a very troubling system when it comes to DMCAs compared to self-hosting, even if they make discoverability much easier. Content on a mod site like Gamebanana can be collectively wiped easily, self-hosting creates an impossible whack-a-mole game.