What AGP Video card is capable of playing new games?

I have a 2.6 ghz pentium 4 processor, 2 gb ram. What is the best overall value for an AGP card capable of playing new games at good resolution, such as Call of Duty 5?