128 MB would do you just fine for C&C and homeworld.

I have a Geforce Ti 4200 which has 128MB of ram and it runs everygame great.
The games I play are UT 2003, Battle Field 1942, Command and Conquer Generals: Zero Hour. Civiliation, Age of empires, and a couple others.