Whelp, if you're looking for AI you'd best give up right away. The absolute most you can do with the AI in sins is feed them money and special upgrades, and try to manipulate the composition of their fleets through roletypes which isn't particularly reliable. The rest is, as they say, lost in the gullet.

AI is just seconday i guess. it's not that Important. Im more interested in mods that expand the games. AI would be a mere bonus. And since i love games like sins of a solar empire, I find the amount of ships, planet types and bonuses too low compared to how much could be done. that's why i'm searching for rich mods. 

No mod is ever "complete" lol.

It just depends what you want. For more content, Enhanced 4X, Distant Stars, and Maelstrom are all good, but focus on different things (Mechanics and Diversity/Research/New Races respectively), while all 3 contain some fairly large overhauls with things like new planets. The "total conversion mods" like Sins of a Galactic Empire might have more new content, but many of the other ones are still somewhat incomplete do to their more ambitious goals.