R.E.A.R.M. - "Rearmament Expansion And Redesign Mod" is an unofficial Homeworld 2 expansion and it adds number of new interesting and various units.
I have a small glitch where the textures will sometimes become ultra-low res, but otherwise, this mod is great!