Sadly no, the athlon dual core is not enough to play any of the latest games, it can barely play GTA IV on its lowest settings and it will overheat, you need WAY more ram, at least 4 gb (I recommend at least 8gb) to run all of the latest games, you need a better graphics card and you skimped on your PSU, a big nono
What is your budget? (so I can configure a better one for you)
I'm really sorry if I sound too mean, but please, I beg you, don't take the budget option!
Not quite sure how much all of this is, but an ASUS F1A75-v Pro (Approx $110 (USD)) with an AMD A8 3870k (~$120) with 8gb of RAM ($20-$60) should be sufficient to run almost any game on its medium-high setting. Keep in mind that the board is an ATX so make sure the case has enough room. And the APU (Similar to the CPU) has enough power in it to go without a graphics card. Although i would highly recommend a Graphics card to go along. This is also very cheap for the power you get out of the components
Looks like one of those PC kits Newegg or Tigerdirect sells. If you have a Microcenter in your area, you can get a i5-3570k for $189 and mother board for less then $100. Trust us that it will run 100 times better then any AMD processor out there.
If you're on a budget get a Sandy Bridge pentium dual core. The g6950 and g6960 are pretty decent CPUs that will be able to handle most games when paired with a good card (I'd reccomend the 7850 since it uses way less power than something like the GTX 560 ti while delivering slighty better performance). Right now I have an old Wolfdale pentium dual core @2.7 ghz and I can run most game just fine. Just don't expect Ultra performance with a pentium dual core, or handling poorly optimized games like GTA IV or really CPU intensive ones like BF3's multiplayer. You can still play a lot of games, mostly stuff that you can get on Steam, like Valve Games.