Make sure you memory is at least 1GB for stock and 2GB for any of the super mods. I got by with a Gforce fx5200 card of a while and went to a Gforce 6200 (my computer has a low profile AGP slot, so card choice is limited!). Make sue your processor is fast enough and you can get as much memory as possible.
You then should be able to play without to many troubles!