Then that card will definitely give you a great gaming experience. If you decide to upgrade your monitor at any point to 1680x1050 and beyond, it will choke up on you, but at that resolution, it shouldn't have any difficulty maintaining enjoyable framerates, Assuming you have a computer that can match. Your questions about AGP lead me to believe you have an older computer, and if the CPU is too dated, this might all be a wasted discussion.
If you have a decent single core CPU (say, 2.5ghz+) and 2gb of ram, you should be fine in seeing a performance boost from that videocard.