If you have no problem with sandbox strategy games yes, you will like it. The Sins AI is much better than in other more popular games, the only reason it gets flak IMO is people who either don't like what little, subtle story there is and want a campaign to explain it. The only real problem is things like a real lack of game modes and other interesting settings, but this is to be somewhat addressed in Rebellion. Also if the game does get boring there are lots of mods to make it interesting again, which if you are a fan of watching space battles is worth it just for that.
All and all, if what you've heard about Sins appeals to you so far, I doubt the single player is going to change your mind.