I have almost the same specs as you, OP. I may just get one final video card upgrade as AGP is at the end of its life. I'm thinking a 7800GS or X1950GT card will likely be more than fast enough for my Athlon XP 3200+, and the CPU will be the bottleneck.
I will wait until Vista is straightened...