Well my setup was very so like yours i have and amd 3500+, 1gig ram and i just bought a radeon 2600xt. Now i can play COD4 very easily.
COD4 is mad onlinee, single player is rather short as i finished it in a matter of hours lol (with no hardcore play).