I just built a new desktop with a $500 budget and I bought a 7750. It really is the best CPU you can get for the money (for a low end budget). Here's my build suggestions:
Cooler Master Centurion case:
http://www.newegg.com/Product/Product.aspx?Item=N82E16811119106
Enermax 500W Power Supply:
http://www.newegg.com/Product/Product.aspx?Item=N82E16817194038
AMD Athlon X2 7750:
http://www.newegg.com/Product/Product.aspx?Item=N82E16819103300
4GB G.Skill DDR2 800:
http://www.newegg.com/Product/Product.aspx?Item=N82E16820231122
Gigabyte GA-MA770-UD3 AM2+ motherboard:
http://www.newegg.com/Product/Product.aspx?Item=N82E16813128376
Radeon HD 4670 512MB video card:
http://www.newegg.com/Product/Product.aspx?Item=N82E16814102820
LG Black DVD burner:
http://www.newegg.com/Product/Product.aspx?Item=N82E16827136152
Western Digital 500GB hard drive:
http://www.newegg.com/Product/Product.aspx?Item=N82E16822136073
Sub total = $447.92
Total with shipping = $479.90 (3 day UPS within the US)
I know it's more than $400, but a few of the products have mail in rebates that could make the end result closer to your budget. I didn't shop around when I made this (and I only spent about 10 minutes on it) so do your own research. However, this should give a good idea of what to expect and look out for with your budget. It's very similar to the system I made for myself about 3-4 months ago. It shouldn't have any trouble playing Demigod (maybe not "maxed out" but pretty high settings) and other past Stardock titles should be a breeze. Seeing as how you're posting this question in a Stardock forum, I'd imagine that would be a concern for you.
I hope this is helpful.
***EDIT***
I found some interesting potential alternatives if your interested.
Better video card (more expensive, more performance):
http://www.newegg.com/Product/Product.aspx?Item=N82E16814102822
Less expensive power supply (less wattage, but definitly adequate for this computer):
http://www.newegg.com/Product/Product.aspx?Item=N82E16817139008
Less expensive (but smaller) hard drive:
http://www.newegg.com/Product/Product.aspx?Item=N82E16822136098
Cost with these changes = $470.25 (same UPS 3 day shipping included)
Again, it is possible you can find better deals elsewhere, but this gives you a good start.