Super units are extremely powerful. They’re also very expensive, they require a lot of time to produce, and they take a heavy toll on your Population limit. For these reasons, Super units generally don’t appear until the later stages of a match.
The UNSC and the Banished each has access to one faction-specific Super unit.