Hi wosgrove and welcome to PCHF! Your Pc will run COD4 and run it quite well, same goes for Sims2 and C&C generals, battle for middle earth will have to be run in compatability mode, but thats easy to do.
D
EDIT: you can try this website>
Can You RUN It? and it will tell you what cames your Pc can run