Why this is relevant to your question is the fact TW's game changes also apply to campaigns (you can get a version for Dark Crusade easily, Soulstorm one is a bit trickier due to some dispute on ModDB). It adds lots of new units and even factions, though the scale of battles is a bit smaller than UO - for instance, UO lets you build multiple types of titans, where TW only has one per each side (if I am not mistaken).
There is a mod called Titanium Wars which is a bit like UO.
