I'm a big fan of Masters of Orion 2, Birth of the Federation, Sins of a Solar Empire, Civilization IV, Age of Wonders III, Heroes of Might and Magic 5.

Am I going to like this game?

Also, how does multiplayer work? Is it pretty standard for these turn based games? Does it have simultaneous turns?

Yeah, considering these games, you should.
There's already a lot of information I wrote in the GoG release thread :
https://www.gog.com/forum/general/release_sword_of_the_stars_complete_collection_9cee6
Check also the various reviews?

I have made a review on the storepage.

It looks like you haven't noticed you can use command ships to increase the number of ships you can field in battle?

You can often beat higher tech, lower industry enemies by attacking them at several fronts at once on the strategic layer. (Up to a point, not if they're so higher tech they can intercept all your fleets with their lower number of fleets before you get to their colonies.)

Then, it's not like there's a single "best" weapon : there are plenty of counters...

How much time have you played and how far did you get into the game?

I played it for over a week, I remembered there was some tech you could research to increase the shipcap but gog doesn't allow me to edit my review.
I know there is not a single best weapon and I never said there was, but it the endless possibiltiy of combinations where only very few work, that is why I said best tech but the game does not do a good job explaining what you're up against. Also I had spend a lot of time watching YT tutorials which I loathe if I have to turn to that.

First, to the OP: you probably will. I've played MOM, MOO1&2, Civ 1 to 5, Alpha Centauri, AoW 2 and AOW: Shadow Magic, HoMM 2 to 5, Fallen Enchantress: LH, Endless Legend and Space, Space Empires 4&5, GalCiv 2, Star Ruler 2, and probably a dozen or so other minor 4Xes I mostly forgot the names of. (Why so many? I easily get bored :P) Out of all those, SOTS is my favorite :) I also played SOTS2, but it's much worse (pressure from publisher, rushed release), only thing better than this one is graphics.

SOTS has a heavy combat focus, with most techs being combat-related. Weapons, shields, armor etc. It has the widest range of weapons I've ever seen in a 4X, with many soft counters. Also, the economy is very simplified - three sliders per planet, mostly set-and-forget. There is barely any micromanagement on the economy side, so it avoids the late-game micro overload that's typically a problem in 4X games.

I'd say that the two main pros of the game are randomized tech tree and unique FTL travel for every of the six races.

About the random tech tree: tech locations are always the same, but the availability is randomized. Aside from a few core techs you always get, it's not guaranteed you'll get a certain tech, and you won't know if it's there or not until you research the prerequisites. Check the tech tree, linked below, for racial probabilities. If you don't have some key tech but your opponent has, there is a chance to salvage it if you win in combat. You need repair ships to salvage techs.

The unique FTL also determines strategies. I'll give you same examples.

Humans use nodelines: heavily limited routes, but very fast movement. Only race that has chokepoints :)

Morrigi (dragon-crows) flock drive increases FTL speed for larger fleets. Solitary ships are second slowest in the game, late-game huge fleets are the fastest in the game. Very vulnerable early game, difficult to scout even late game.

Hivers (bugs) don't have an FTL drive, but have a gate network. Once your gateship slowboats to a star and you open the gate, you can reach it in a single turn from any other gate. Open gates are a priority target for all AI players. Very strong on the defense, but impossible to surprise an opponent when attacking. Bring enough ships.

There are also Liir (flicker drive, slow near stars, fast in deep space), Zuul (use nodelines like humans, but they create their own with boreships) and Tarka (warp drive, the only classic one). Tarka are recommended for beginners.

Check techtree on http://chariot.nickersonm.com/ANY_TechTree.html
Also, wiki on http://wiki.swordofthestars.com/sots1/Main_Page
The tech images on the techtree link to the wiki, but the wiki has moved in the meantime so the links 404. I wrote a short Greasemonkey script that rewrites links to point to the new wiki: Check the above tech tree, C3 section (a bit to the right of center, between Ballistic Weapons and Xenotech).
Also, if you outnumber the opponent, you get bonus command points. According to the wiki, "every 5 ships that you outnumber the enemy gives you 2 bonus command points, no matter what size those ships are", though the comparison is capped at 20 destroyers, 70 cruisers and 120 dreadnoughts. The cap means that if your opponent has 15 destroyers and you have 30, you still get only (20-15)'s worth, or 2 CPs (one bonus destroyer). Some relevant links:
http://wiki.swordofthestars.com/sots1/Command_and_Control
http://wiki.swordofthestars.com/sots1/Command_points You don't have to watch YT tutorials. You can read wiki or official forums, if you prefer reading as I do :)
Also, wiki (yeah, I know, I'm becoming obnoxious with that) does a pretty good job with explanations of various weapons and defensive techs. A lot of information up there really should've been in the game, like damage, reload time, range, which improvement techs apply, which defensive techs act as counters etc.

One more thing that may help you, research the Data Correlation tech in the C3 branch. Check the icon on the top of the screen that looks like a magnifying glass, between diplomacy and ranking. Without this tech you can see only your own data, with the tech you see known enemy techs and most recent 20 or so designs that you have encountered.

I have many more tips & tricks, maybe I'll collect them later in a post... If someone needs anything specific ask :)

Thanks, you guys rock. It does sound very interesting because people keep mentioning it's re-playability. That was the downside of MOO 2 was there were definitely a set of tech that was much better than the rest, and I got sick of SoaSE because of the whole Titan thing introduced in the latest version.

I think I'll give it a try, though it's a bummer to hear it doesn't have simultaneous turns in multiplayer like Moo2 had.

No problem. It is simultaneous, both in MP and SP. In the strategic phase, all of the players give orders at the same time, and the execution happens simultaneously when everyone clicks "end turn" or the turn timer runs out (turn timer length is set - or turned off - during map creation). After that is the combat phase, where you can choose if you want to fight manually or auto-resolve for every combat in that turn.

I heard that in MP there is usually a verbal agreement to manually fight at most one combat per turn, since while you're fighting other players are twiddling their thumbs (I played a few times in LAN, but mostly SP). New turn starts when all combats are resolved. You can use the interface normally while others are fighting, but you can't give any orders (e.g. fleet movement, build orders, changing research...) until the next turn starts. You can use the ship designer, though.

BTW, when you load a game, there is a screen with some basic information about players. Here you can drag-and-drop your race info card to another one to swap places with that player. This works both in SP (e.g. swap places with an AI to check progress) and MP (e.g. when loaded in wrong slot, or replacing players after someone drops).

Well good, I read in a few reviews that said it wasn't. I was surprised since simultaneous turns has kinda been the norm for such games.

I've actually given it a try, only had time to play a little in the tutorial, and I'm probably getting rocked, but it still has good potential.

It's like the took the most fun game mechanics they know of, then simplified them as far as they could. I like it!

If you're running this on a 64-bit OS, then I highly recommend running the 4gb patch located below, on the Sword of the Stars.exe. This will increase the games accessible memory from 2gb to 4gb. And will prevent the game from not being able to load large manual battles later in the game.

www(dot)ntcore(dot)com/4gb_patch(dot)php

Take the written (dot) out of the above address and put in the proper periods. If any veteran posters will verify it's safe and not something malicious, it would be appreciated. I know that it's safe, but I'm sure others would appreciate some assurances.

I have a 64 bit OS would like to know if link is safe too.
Well avira says the site is ok but the link i haven't tried,i think i set my virtual memory to 1000-2000 so it wouldn't make any changes then.
Btw i have 4gb of ram

Nothing to do with running out of total memory - rather it's about running out the 2GB of memory that is (was?) the default limit set by Windows for 32-bit programs :
http://www.kerberos-productions.com/forums/viewtopic.php?f=16&t=17951

(Which allows to increase this limit to ~3.25GB : maximum 4GB = 32-bit minus memory taken by hardware and stuff.)

Fonzer I'm sure I worded that poorly and probably just made the app seem unsafe. As it explains at that link, it's a tiny little 44kb program, that just patches the game exe to make more memory accessible for a 32 bit Windows program. I've been using it for several years, on all of my older 32 bit games, that I felt could benefit from access to more in game memory. It's never caused any game I've used it on a problem and for myself I know that it's safe to use. I was trying to get anyone else who knew of this little program, to provide further assurances that it's safe to use, for those not familiar with it.

So meaning i can probably make saints row 2 work even better with this?
It's currently the most played game i have from gog while it runs decently it could be even better on my 2009 pc.
I still haven't installed sword of the stars but i am gonna try this patch then.
Lots of games are only with 32 bit executable and i didn't even know about this before until you mentioned so thanks.

Edit:Installed the game and used that app,i will begin playing when i will have enough time,seems like just the tutorial selecting humans had much text there about them so probably gonna play when i have more time.

I wouldn't expect it to have any effect, unless your game was crashing due to running out of memory?