I play with a GTX570 and I get frustrated. The load on the GPU only gets hit ~25-60%, but with lots of mods the ram usage just gets pegged. So it is not that you need a super high end GPU setup to play... but the more ram the better.
2GB minimum, preferably 3GB