There are two categories of special forces in Starfleet. Within Starfleet Academy, there have been at least two special groups: the Nova Squadron and the Red Squadron. While in the Academy, certain people (Reed, Bashir, etc.) have been recruited for Section 31.
MACOs, although not seen in any Star Trek series except Enterprise, do actually exist still in 2409, so apparently they were around somewhere in the other series.