For the Linux side, I've used Mod Organizer 2 on Linux via https://github.com/Furglitch/modorganizer2-linux-installer
The problem is that the Linux compatibility stuff is the first step, and as the Skyrim modding forums will tell you, getting Skyrim modded is basically a game in-and-of itself. There are various incompatibilities between different mods, load orders matter, and so forth. It's not a low-effort path.
Like, the real answer is that I don't think that there is really a great low-effort way to get just "modernized Skyrim" up and running. That's not that I don't sympathize
I think that there is real demand for someone who just wants a vanilla-with-a-lot-of-community-updates Skyrim with minimal effort and troubleshooting. I've done it, and it takes time to debug issues.
Also, there isn't just one "modded Skyrim". There are people who want to play a vanilla game, just with higher-res textures and higher-polygon models. There are people who want more changes, like cities that smoothly transition into the open world. Some people want a seriously modified game, like a survival game. There are people on LoversLab and similar who want an erotic open-world game. And those just aren't really compatible with each other.
I have never used Wabbajack on Linux successfully
haven't tried recently, either
but it downloads entire collections of pre-set-up mods. The idea is that it has some "pre-modded" configurations to start from that someone's tested. You don't get to configure everything, but in theory, it should "just work" on the Skyrim side of things, and it's the closest to that that I'm aware of.
EDIT: It looks like Wabbajack has "unofficial Linux guides" up off their main page, so some people are clearly using it on Linux these days.