Legacy of the Confederation: Fallen Angel by The Oracle
Playthrough: https://www.youtube.com/playlist?list=PLACFHAM2MlxNqgmviFjKo2Qp_TYNAirfM

Sometime between the first two LotC campaigns, an elite sniper squad reaches new levels of cringe.

5 playable missions, 1 cinematic, modded executable for version 1.16.1, nearly-fully voice-acted
Not recommended on the grounds of intolerable level design, a complete lack of organic macro gameplay, and buggy triggers.