Mount & Blade, especially its mods gave me (and thousands of others) a lot of satisfaction in this department…
Xenonauts, although its basically a new X-Com… but otherwise I have been dreaming of someone making exactly this game!
Gentlemen I implore you! Build this game to be expandable with content, because it will attract people, and modding is about keeping them.