I'll let you in on a secret: I've never even seen a Super Unit in Heroes, let alone achieved it. I don't even know what they are, except that they exist.
Humans deal 3 times more damage with Overseer (Leadership + Defense + Light)
Demons are summoned instantly (Logistics + Darkness + ?Luck/Attack?)
Necromancers shout 4 times louder (Summoning + Leadership + Education)
Warlocks deal 30% more damage with elemental spells (Luck + Chaos + Sorcery)
Elves always attack with luck (Light + Luck + Logistics)
Mages learn all spells at the Expert level (Machinery + Education + Sorcery)
Dwarves attack with bad luck on a normal attack and just a lucky attack (Summoning + Defense + ?Leadership?)
Orcs gain 500 points of Rage (Leadership + Machinery + Attack)
It's easiest to get a Super Unit with a Warlock and an Elf, because these skills are fundamental for them.
I probably made a mistake somewhere.
You must have seen Super Units for Talanar in "Higher Vampire" and "Defense".
Added after 1 hour 44 minutes
What's the new Super Unit for the Tower?