You'd need to post a little more about your taste in games for someone on the GC2 forums to guess whether you might like the game.
The base game is sub-titled Dread Lords. The first expansion pack is Dark Avatar, and the second is Twilight of the Arnor. IMO, the expansion packs are unusually strong for the turn-based strategy genre. They each add significant new aspects to the base game, and there's diversity of opinion on the boards about whether to jump straight into TA or spend a bit of time with DL and then DA.
The official screen shot collection is here. Tons of questions, answers, comments, gripes, praises, and unofficial screenshots are available at forums.galciv2.com.
(edit) Oh, I forgot to mention that I am very, very fond of the whole GC2 series. I've never cared about multiplayer, dislike real-time anything, and basically play only TBS genre games. Civilization 1 got me started in that rut.