Nexus Mods is fine, it takes a lot of money to provide downloads for e.g. massive texture packs to hundreds of thousands of people. They take reasonable steps to prevent abuse. The alternative would be to burn through cash to get more users, then sell to a supercorp who would milk it to death. We don't want them to turn into Fandom.
If you are a mod author, you can also earn Donation Points from people downloading your mod(s), which can be used to get free Lifetime Premium (fast, unlimited downloads).
Personally, I find that mod discovery is more of an annoyance with the site than anything else.