I appreciate the replies and suggestions. Nvidia is really the only gpu I know and would like to stay nvidia but i'll take a look in to amd's. I had a gforce 8600 gtx and played borderlands, Dragon age, Age of conan and BFBC2 on it until it crapped out when I installed dragon age 2 for some reason.
I can't really afford a cpu upgrade because i'm also in the middle of an ar build, which is why I'm asking for the best card possible w/o bottlenecking.
I've been looking mainly at the geforce 4 series and the gts 450 with being the highest I can go but I really don't know which is why I'm asking.http://www.newegg.com/Product/Product.aspx?Item=N82E16814127606
Edit with an I'm new I don't know what to do question. I'm considering the antec neo kulmnar suggested. It has a 20+4 pin and my mobo is 24 pin. does that just all plug in to my 24 pin?