If you're buying budget AGP go either 6600 GT or 7600 GT (on the nVidia side at least). I seriously reccomend nothing else if you actually wanna be able to game.
Sure a low budget card like a 9600 will run BF2.... but with 30fps on all low settings? No thanks.