They will probably just try to pay modders more for their mods on the official store than what Nexus is paying them, by charging users a microtransaction to download each mod. Modders probably will make so much more money for their mods, that they won’t want to upload to Nexus or anywhere else. Also, there’s no way that Bethesda is going to allow nsfw mods on their official store, so I guess we’ll see what happens.
The linux motto to any problem is “it’s possible, but here are the pitfalls”. You can do almost everything on linux (unlike windows), but the tradeoff is it can sometimes require more time to learn and troubleshoot issues. In my opinion, linux is great for those of us who dislike to use the mouse and take our hands off the homerow. Get used to using the terminal to launch apps, instead of clicking stuff on the desktop. Learn keyboard shortcuts. My recommendation is to use a window manager like i3 with an i3 status bar at the bottom. This will give you a minimal desktop, where you can move windows/tiles around all with keyboard shortcuts. Open apps with something similar to dmenu, where you just have to press a keyboard shortcut and type the first few letters of the app you want to open, and press enter. Learn vim-like keyboard navigation to edit text and reposition the cursor through the text all without the keyboard. Linux integration with this style of experience is vastly superior to Windows and Mac.