OFP: Resistance is one of the best FPS campaigns and it's a damn shame it doesn't get more recognition hear. I haven't played Hidden and Dangerous 2, but I've wanted to for a long time. I wish 2K would release it on Steam or GoG along with the Vietcong games
Can't get SWAT 4 or Rogue Spear either digitally, right ?
Honestly, I wouldn't wait around if you're a fan of tactical shooters. Especially if you're a sp guy, as all the new stuff like Arma, Red Orchestra/Rising Sun, Insurgency... all seems to be mp focused unfortunately.
I know making a substantial/proper campaign takes a lot more time, effort , creativity, $ if you're gonna do it right and these games aren't exactly the most popular genre, so it's not really surprising, I guess.