That's the same card I was thinking - definitely 46xx range is as high as I think you can go with AGP, but as stated, it will more than likely be bottlenecked by your CPU.
If you can spare some more money, it may make more sense to update the entire system - there are some really solid budget systems out there that will give you some good years.
It depends on your budget and what you are looking to do with it.