You can play on the max settings forever @ 1024x768 lol. But like Kanewolf said these new cards don't have DVI-D ports so you can't use VGA. You would need to buy an adapter. They are only $15 max on amazon.
Unless you are using a P4 still, I don't how the CPU could hold you back at such a low resolution.