Ya, that 8800 that allen linked to would be plenty to run COD4, that's the card I started with playing COD on, great card. It won't run newer games maxed, but it'll play them decently.
The problem you're going to run into is not your GPU, but your CPU. Newer games are going to rip that 3700 to shreds..