You can play any for any mode. None are exclusive to any particular one.
Regarding modding AI in general, there isn't not stand-alone mod for that. It's moreso optimizations done within the mod to utilize all components.
Probable the most widely used one would be Distant Stars. If you want additional races, play Sins of the Fallen and Maelstrom (this one has a powergap between new and old ones). There are themed ones, too. Regardless, I'd stay away from 7 Deadly Sins. Great foundation, but the mod has never been stable. They jammed too much into it.
Many of the projects listed are a WIP, and have been for months.
Index: https://forums.sinsofasolarempire.com/423212