I'd say it's worth buying it. Your system is OK, especially if you'll upgrade the CPU later. Still, the 7950 might be moved to legacy status anytime. Maybe next month, maybe next year. AMD has no official lifecycle plan for these cards, they get rid of them whenever they need extra money. I'd wait for the 8k series or check out the other side of the force.
CPU: AMD Phenom II X4 810 @ 3250MHz | RAM: Kingmax 2x2GB DDR2 800 @ 833MHz| MoBo: MSI K9A2 CF v1.0 (BIOS: 1.D)| GPU: Asus HD 6850 1024MB (DirectCu) @ 850/1100MHz | Display: L24FHD | PSU: PC Power & Cooling Silencer 750 Quad | OS: MS Windows 7 Pro x64
CPU: Pentium 4 Northwood S478 @ 3200MHz | RAM: 1,5GB DDR 400| MoBo: Gigabyte GA-8S661FXMP-RZ | GPU: ASUS Radeon X1650 Pro 256MB | Display: Dimarson 19" CRT | PSU: Noname 400W | OS: MS Windows XP Pro