Just some of the many problems that still plague this game can be found in the preview of the upcoming patch (and bear in mind the patch might not actually correct these problems and might actually create new ones). The preview can be found in this thread.
I guess it depends on your budget for games. I've been holding out since release, because of the bugs - but ended up buying it last week. And to be quite honest, I haven't noticed a single bug yet. I've watched plenty of the bug videos regarding for instance traffic, and yes, traffic can be a mess, but that's sim city for ya, and I have yet so see anything gamebreaking or even close.
So depending on what kind of player you are, and what kind of budget you have, it could very well be worth picking it up now.
It's been well worth it to me so far - I'm enjoying it.
ULCE #: 12.834 ~ "I don't need luck, I have ammo" ~ Grunt, ME3
I found a copy in an online sale for £25. I've played it for about 40 hours or so and have yet to encounter any problems. The value for price ratio isn't bad. I've spent more than £25 on a lot of games and not given them as much play time.
"Have to start remembering there are 4 versions of reality.. past, present, Ea and pr.." - xoxide124
If you have spare income to spend and can find it on sale, I'd say "go for it". I grabbed my copy on sale a few weeks after release and aside from traffic having a case of the galloping stupid, I haven't had anything game breaking happen.
The two more recent patches have helped a bit, so I'm content. Though, I'm not jaded be release-day issues like most here. As far as I'm concerned, traffic is still a bit dumber than I think it should be but I think this is more "working the kinks out of a new game engine" over anything.
tl:dr - Yes, if you can get it for cheap. While it is enjoyable, I can't recommend it at full price.