Hi Century and welcome to SimV!!
Seems like a decent system. I recently got the BFG Tech 6800GT OC AGP 256MB. I am getting good FPS with it and if you would like to see some the shots, have a look
here

Keep in mind though, I have only had FS9 for about 4 months now, so it doesnt look its best. Eventually, after many tweaks and settings you should be getting good shots along with high FPS rates. At current, I get 60-80FPS in rural areas. It usually dips down to 25-30FPS in highly dense areas. I have everything in my FS9 maxed out. Along with some payware scenery such as the LAGO Rome scenery which is highly detailed, I get around 20FPS. Very manageable. The Fly-Tampa Series also takes it's toll on FPS, but not as much. My Dubai and San Francisco FPS usually stay at a healthy 25FPS.
As for y unew Video Card, I can suggest the GeForce 6800 GT PCI Express 256 MB. You could try tweaking your FS to make it look good with your current card.
Cheers,
Ashar