This is a perfect example of why I swtiched from PC Gaming to Consoles. Sim City looks to be another great game to come out on PC but unless you have the system requirements similar to what Walt Disney Studios use to create animated movies, there's no point in getting this game. Sometimes I wonder if these game developers are in cahoots with Microsoft. Seems that everytime an awesome new game comes out (which I'm sure the new Sim City will be), you either have to totally upgrade your pc or get an entire new one. I'm a big Sim City fan having played the older versions but I refuse to get suckered into having to shell out more money just to be able to play it. I would love to see it adapted as a console version even if it doesn't have all the graphic bells and whistles. Sim City is a great game which can stand on it's own. But until it's developed and marketed for computers that aren't capable of launching the Space Shuttle, people won't be buying it no matter how good it is and that's a real shame.
I hate to point this out...but consoles are nothing more than low end computers with mediocre to good video cards. Providing your PC is ~2 years old or less, invest in a decent video card, pop it in a PCI express port and you should be fine. If you are relying on only integrated video (i.e. Intel 3000 on Sandy bridge processors or 4000 on Ivy bridge), then no, your PC won't be able to handle much graphically. I can only make assumptions based on the lack of PC specs you list...but what I know is I built my own PC 4 years ago and done nothing but upgrade my video card (currently using GTX 580) and everything runs perfectly smooth.
Yeah. I spent $400 on my PC like 4 years ago... I've since spent another $300 or so upgrading the graphics card, RAM, and hard drive (SSD). It'll run anything I've thrown at it no problem. You're looking at spending almost that on consoles if a new generation comes out every 5 years or so. But it does a lot more than a console, and I need a computer even if I get a console, so I'm not really saving anything by going console. PC games tend to have more customization and they can be a lot deeper. They also can have better graphics. Add to that cheap video games through Steam sales and other sources and PC gaming wins out easily in my opinion.
Of course new games that have better graphics or more happening in them that require more processor power are going to need decent computers to run them. If your computer can't run it, then it must be ancient. I'm running SimCity on a laptop that I bought in May 2009, and I'm having no problems running it. If you can't run it on your PC, then it's either an ancient machine or a bare bones machine.