Mostly my fault. Should have done more homework on this game. Didn't know it was so slanted toward multiplayer.
Here are my problems with the game:
--Single player skirmish vs comp wasn't enough for me. Where's my campaign or story? Why bother with a long intro movie if there's no follow up? Most RTS games have both so why can't Sins of a Solar Empire?
Short answer because sins is not a RTS, it's a hybrid RTS and 4x (RT4X).
Long Answer is the game is designed as a 4x game but with the RTS feel, this is what tends to mislead people. Most 4x games are just the sandbox type game, which sins is the same in this regard. Although Ironclad/Stardock has said they may do a campaign in a future expansion.
--UI doesn't work for me. Design makes it easy to miss stuff. And you have to micromanage research and production too much. Sure you can queue stuff but that's impractical given the steep resource drain and the competition for resources between research and production. Mostly you build a tech...then you wait....then you build a ship...then you wait...then you build a civic research station...then you wait some more...whoops you just got invaded so all the stuff you had in the queue you've got to ditch cus now you need ships.
Nothing you listed above is a bad thing IMO, All those reasons you stated as a fault is what makes this game good. You have to pick and choose and there's more than one way to go about winning a game, in other words its called STRATEGY, look it up at dictionary.com if you don't know the meaning of the word.
--Like Eve Online you can zoom in and see your ships but you never really do because youre managing so much other stuff. Plus the ships basically fight for themselves so you barely even need to watch them. So basically your working with tiny blips on your screen all the time. Really kills the immersion imo. In the RTS games Command and Conquer or Dawn of War you feel much closer to the action and that really adds to the fun of the experience and hides the pain of all the waiting for research or production to finish. Turn based production/research with RTS battles can help solve this problem.
Again you are comparing this to an RTS game when it's not. 4x games or in the case of sins and RT4x are designed to be played around the bigger picture such as running an empire, exploring, exploiting etc, etc.
--Should consider an option in the future that allows Sins of a Solar Empire to be played as a turn based game with RTS battles...like the great Masters of Orion. This would allow players to zip through the production and research phases without the long wait times, and then focus in on the battles. They only strength the real time aspect to production and research brings is it keeps multiplayer games moving along. Now that's important and definitely should be kept for multiplayer games. For a single player it's just a pain waiting for everything to finish being built or researched. I just want to hit the next turn key...but I can't.
This idea would entirely change the make up and the features the majority likes about the game, not only that this would more than likely take a complete rewrite of the code base to implement.