Yes it is very interesting how the comment section is overtly negative yet NexusMods is one of the rare thing that "just works" for me. Even my girlfriend who is not well-versed in tech at all mods her Skyrim/Oblivion herself thanks to how easy it is with NexusMods.
Judging by your two's comments, there seem to be a mismatch what people think of when they hear "Nexus Mods". Originally, it was just a website where people uploaded mods, and others downloaded them and manually re-organized stuff on disk, or with some game-specific mod manager.
But what you two seem to be talking about, is the relatively new mod manager that Nexus also has, which basically allows you to one-click install mods.
I think many comments talk only about the website (in isolation), while both of you are talking about the mod manager, hence the mismatch in experience.
As an occasional user of either form of NexusMods, both have been worth paying for in the recent past. The last time I played through SDV I had approximately thirty mods that I hand-installed because I was patching them locally to improve weather handling and learning C# from it. I’ve also used the mod manager to do a couple other games that badly need the improvements (“Stop Wasting My Time” is the best mod ever) and that I wasn’t modifying further. In both circumstances, I paid for a membership to support them, and I ended it when I stopped playing the game I was modding. Glad they exist and will continue to pay them when I use them, especially if they continue to be opinionated along current lines.