This workshop skews heavily toward quality-of-life and balance patches rather than content, because the base game's crafting and stat systems are dense enough that players want to tune them. Several of the top mods are openly cheats, and say so.
Ranked by hand, not auto-generated. Every mod links to its full page with install guide + compatibility.