Unit carpet isn't hard to fend off. It requires a small battlefront (choke point), takes a very long time and is tedious. Eventually the AI just stops building buildings and economically falls behind, since unit cost ramps up and they aren't getting any yields from successful warring.
A superunit squad will just plow through your choke points, UNLESS you also fortify them with superunits, which will require you to have an even smaller battlefront. Overall no changes to war duration and tedium, just a reduction of maximum battlefront size for the humans to hold off an invasion.