It could have been great. It still isn't.
Talking of looking dreadful, the graphics have quickly grown stale and tired, with EA's tried and trusted formula of making sure that graphics scale to almost any machine providing us with bland, blocky toy-town buildings, hideous sprites and laughable foliage. Graphical glitches and bugs abound, or the graphics are just so bad that they appear to be bugged.
The game was so full of promise, and the legions of naysayers that doubted the ability of the series to resurrect itself have been vindicated totally. A crying shame, but hopefully not entirely without hope: with the Maxis studio now alive once more and The Sims still keeping the simulation end of the business very much afloat, there may just be enough incentive for them to try one last time. A blend of SC4's harsh yet realistic learning curve with some of SC's exciting and dynamic new features could just be the saving grace of the series.