Of Mods and Drama

(Sorry if this is the wrong flair) I took a break from Skyrim around 2 years ago. I've recently got the hankerin to play it again so I've been looking for mods. In my search I've noticed three things: 1. Everyone hating on USSEP and Open Cities, when previously they were beloved 2. The Nexus is filled with porn/porn creation mods 3. Every time I search for best mods of 202whatever, the same best mods have been coming up since 2014 really.

The fuck happened with Arthmoor that everyone has a distaste for their mods?

Where do I find good NEW mods: quest, mechanics, and followers mainly

Do you have any recommendations for an assassin orc mage playthrough?