Special Forces has to be a real tough unit to portray. It is, at some basic level, a generic warrior with March and Combat promotions up the wazoo, See Invisible, HALO or special SeaOps capability and most importantly, a Hidden Nationality promotion!
We used to say that to be successful an Op had to be carried out in such a fashion that the target was never sure we were there, or at least had no concrete proof (Charlie Sheen movies not withstanding). The mission simply did not have much of a chance of success if the team was discovered. It has been posited that under these rules Delta Force has never had a successful mission! The SEALs fare a bit better.
Finally, SpecOps either precedes 'Stack' combat, or is a stand alone mission that the current Spy unit does for Civ IV.
BTW, the 'Promotions' mentioned are partly earned by the generic warrior, and then augmented in special training schools. These are not learned in the field! If you don't have them, you are not going on the mission. Again, apologies to Charlie.