When in doubt, use google. Search the term "Sins of a Solar Empire Mods" and you'll find what you're looking for. I'm fairly sure Stardock still has a distribution service for Sins content, but my experience with it was fairly poor (took over a month to get the content I'd submitted approved, by which time a patch had invalidated the file format)
