If you start getting into mods (where some of the best fun in MTW is found), there won't be any unit guides for most of them.

One solution is to download the Gnome Editor v2.0 (11th from the top of the list), install it, load the unit prod file, and learn to read it - the stats for the units are all in there.

It's a little clumsy, but works for any variant of MTW - certainly better than nothing.