I love Silent Storm. Especially when you use a mod to remove those stupid power armor from the game. Just stay away from KGB, a game from the same dudes. It is horrible. If you are into tactical shooters, have you tried the old classic, Jagged Alliance 2? It lacks all the nice physics and terrain Silent Storm has to offer though. X-COM series is another classic in the genre. Altair's Ufo Afterlight isn't too bad either.
Current games... that is harder to find. There is new Ufo Extraterrestrials game coming out soon, the first was a...lackluster X-Com clone. Maybe the sequel is better, we will know in a month or so. Have you tried Total War series? Shogun 2 Total War came out recently and it is pretty good. Though in that serie, the games only really shine with big mods like Stainless Steel for MTW2. The vanilla games just don't manage to give everything they could.
If you are into 4X games, I can recommend Distant Worlds with the expension. Sword of the Stars is pretty good too with all the expansions, you can get a package deal for that nowadays. DW is recent, SotS is done for though there is SotS II at the works. My problem with SotS is the lack of diplomacy, but it is pretty good regardless.
If you are into multiplayer games, then... Dominions 3! Dominions 3! Dominions 3! It doesn't look like much, but underneath there is a heart of pure astral pearls.
If you can narrow the requirements, I'm sure I can come up with more recommendations, being mainly a strategy/tactics player myself.