unfortunately i find the same issues with strategy games time and time again, from c&c original to everything now. you can generally win any map using the most basic unit in masse and its easier to do that in the end than build up a lot of more expensive units that are "better" but do the same job. to a point its often easier to use a single type of unit as the way control works, crappy AI, wall hugging, stupid opponent ai it all becomes very silly to try and really use different style units well. of course a lot of that doesn't stand up to multiplayer but most games spend a significant amount of time on single player and i always find campaign mode more interesting than multiplayer on strategy games.
yuri's revenge rocked, but all i ended up doing would be building 5 prism tanks, 2 mins of small fights and they are all veterans and unbeatable by anything, worked on any map, any level any opponents.
the only thing i'd say i really found awful about galactic civ 2 is the technology researching. research is fine and dandy and part and parcel of a lot of strategy games but there were literally like probably 150 or more different things to research. it wasn't clear at all what you needed to get certain ships, takes way to long, and i won almost every level i bothered playing without getting any really good units or good anything. it turns into a very boring games as the research and ultimately any fun ships just don't become available until a ridiculous length of time into the game. most boring strat game i've played i would say.