You need a much better graphics card, and possibly a new power supply to power it, depending on what came with your system. Newer games do prefer quad core CPUs, but a CPU upgrade won't really benefit you until you get a new graphics card.
Crack open your case and post exactly what power supply you have, and post a budget if you want recommendations on a GPU upgrade.