Should you get it? Yes, I still install it occasionally and play a game or two. The graphics and interface may be old, but gameplay is king.
If you've never played it before, and don't know the areas in which its over-powered, you're in for a treat. The atmosphere is great, and the flexibility in terms of Social Engineering, unit design, diplomacy (which was years ahead of anything else out there) and the uniqueness of each faction. Play as the Morganites, rape the planet clean and then buy out everyone and everything. Play as the Gaians, go full on tree-hugger and swarm the planet with your mind worms. Play as Miriam, and have everyone declare war on you!