Recommended Mods / Where to Get Them?

Just learned this community exists, and I am thrilled!

I want to get back into this game, as it is one of the best games I have ever played. What are some must-have mods recommended by the community? Also, where can I get them? My go-to website, Nexus, only has two mods...

Thank you in advance! Great to know there are still people enjoying this masterpiece :)