Yea, got it, played it (single player, I hate multiplayer games and generally hate RTS) and burned out on it.

Anyone who has not played Dominions 3, and likes fantasy-themed turn-based strategy games, should at a minimum try the demo.  It is absolutely phenomenal, and very, very deep.  You can play for months and months and still discover new things constantly.  I loved Age of Wonders and Master of Magic, and this is sort of like a cross between those and Shogun: Total War.  But much more complex.  Unlike those three, you do not directly control battles, only give troops initial positions and broad orders, then hope for the best - vastly more control than a typical "auto-combat", but nothing like the battles in the Total War series that could take forever and required constant active mouse-clicking.

http://www.shrapnelgames.com/Illwinter/DOM3/DOM3_page.html

Otherwise, for people who DO like action/adventure/RPG games, Mount and Blade is certainly fun, and also has a good demo.

I'll 2nd Knights of Honor...really well put together game. It's one of those games that's simple enough to pick up quickly, but not so simplistic that you'll get bored of it very quickly (if at all). Hell, the only reason I stopped playing it was that I started played Europa Universalis 3.

And even though they're technically RTS games, pretty much everything Paradox has put out is a large scale strategic longform game...there's nothing resembling a clickfest to be found.

http://ufoai.sourceforge.net/

If you were a fan of the classic X-Com series, you might want to give this a whirl. I got hooked when I did. It's incomplete, unfortunately.

Try Armageddon Empires. Post-apocalyptic TBS boardgame. Addictive:]

http://www.crypticcomet.com/

You'll find a demo there, it's definitely worth a try.

Primarly TBS and the occasional RPG. I hate RTS with a passion bordering on irrationality, so while Knights of Honor has some good mentions here, I know I'd hate it.

I played Dominions 2, but I might check out 3. Played GalCiv I&2 and Space rangers. Good stuff. Sadly, I've already played Armegeddon Empires and now I'm looking forward to Vic's next game later this year. Played a lot of Blood Bowl, probably 60-70 games and finally got sick of beating up on the crippled AI

Maybe I'll go back and break out one of those previous ones for a while. I never did finish Space Rangers 2.

Hmm, well, Im really enjoying Kings Bounty:The Legend.  It's a turn based (in the battles on a Hex grid) tactical RPG with an appealing presentation, and a sort of quirky addictive charm.  You might enjoy giving that a look in the Impulse store.

As for SR2, the impulse store now has an expansion for it ("Reboot") that I'm told significantly enhances the original game, if you were going to return to that.

As far as "Turn based " strategy, there havent been any really good entries in that genre for a while that I can think of, assuming you've played all the classics.  The most notable one I can think of recently was Empire Total War (Turn based on the Campaign Map, not the battles), and that game has reportedly seen patches to a number of issues that hampered it at release, if you were of a mind to check that out.

 The most notable ones in the "spirit" of TBS games current now (Like EU3 and next week's HOI3) use that "continuous turn based" model that unfold in real time, but arent RTS. (You can pause and issue orders at any time, then start time moving again, so you get to plan strategy at your own pace, like any TBS game)

I am playing Oblivion myself. Not to bad as a game. Does need a monster to run perfectly however...

Demigod. It's not eactly what you are used to, but it is really fun. Download the demo. It runs fine on my 1.76 dual core laptop.

The Battle for Wesnoth

Actually, that's a good idea. It's pretty much what you are looking for, and it's free. I wasted like 2 days playing it last year. Not bad, especially for free.

Imperium Galactica 2 is a classic and combines 4X and RTS much like Sins of a Solar Empire did. Skip IG3, though.

I recommend hitting the indy scene, games such as Dyson - a very unique take on RTS - can prove to be a worthwhile distraction.

Most new games are not very good, since they are more 'corporate'.  Older games also have the advantage that they could be made by just a few people, which allowed a strong vision and more focus on gameplay.

I can't strongly recommend anything else, but you might try Japanese tactical RPGs such as the Fire Emblem series or Yggdra Union.  They're cute, at least

Oh...  and Disgaea, for PS2.  That's also a tactical RPG, but a couple notches above the handheld ones.  I enjoyed it a lot, and in fact, have around 300 hrs clocked on it...  the game proper is about 60 hours, but there are unlockable levels and bosses that are vastly more powerful, so beating the normal game is basically the beginning of the 'powergame'.

TRPGs are not really much like strategy games in which you control cities, though.