Well, Vista is supposed to be available in retail stores by Jan 30, 2007. With some such a short time horizon left before it's release, why not just just wait? Why spend any money on your old computer?
Having said that, the video card I mentioned is one I believe would be a good, fairly low cost, short-term upgrade. Now, Track, our resident video card expert, may have a different opinion.