If you can source one cheap enough, then I'd say it's worth considering (save for performance under AA). I would be inclined to look into overclocking your cpu at least a little, it may well be very beneficial for minimum / average frame rates in the more cpu dependent titles.
On the other hand, a 7950 should be a smoother experience, overclock considerably further than a 5870, and require a lot less juice. It should also handle AA better and provide better results when using mods / high texture packs, as it has a shed load more memory.
Edit : Marine makes some good points there, and although imo you would see benefits to upgrading to a second 5870 / 7950, I agree that you won't get the very most out of it on that cpu (in some cases there would be a lot left to be desired). I have a Q6600 overclocked to around 3.4 / 3.5 with a gtx480, and although I'm delighted with the performance of the card, there has been the odd occasion when the above has become apparent, e.g. a demanding mod that I recently played, where the minimum fps were borderline. Any less, and I don't think some sections of the game would have been playable for me.