It is not surprising that the Spec Ops's primary function is not reconnaissance anymore (who needs reconnaissance in the Atomic Era?)! Its awesome maneuverability and a powerful ranged attack make it ideal for engaging in guerrilla warfare. Moreover, its ability to directly attack support units in a formation makes it a great counter to Supply Convoys and siege units with Drone support. It's a good idea to keep at least one Spec Ops around for defense in the final eras of the game. Don't be overaggressive with this unit though, as its Combat Strength and Ranged Strength are on the lower end of the units in this era.
Civilopedia entry Edit
Some military problems carry severe risk of failure if resolved with purely military solutions—sensitive political fallout, extreme weather conditions/environmental hazards, or an outraged and resistant local populace. Special ops (short for “special operations”) are soldiers uniquely trained to handle these difficult situations, ranging from combat and reconnaissance to political or civil affairs. They rely on superior skill, tactics, and equipment to complete jobs that would otherwise be impossible for larger units, training in foreign languages and customs of their operational theaters. Their strength lies in their creative approach to engaging an enemy and their capacity to act without hesitation, no matter how unconventional or dangerous a situation may be.
Everything we know about Civilization 6: Rise and Fall - PC Gamer, November 28th 2017