I have a Sapphire X800GTO. The X800GTO has 12 pipelines, but has 4 unlockable - which Sapphire (the one with the BLUE PCD board) unlocks them from the factory.
This is a very good card. I run BF2 all on high settings, no AA, @ 1024x768 res and get anywhere from 50 - 90FPS, sometimes 30 - 40's if there are 64 people.
However, it does run a bit toasty - mine got all the way up to 89*C! The card won't be damaged or anything, but it acts as a pretty good furnace - so you might want to consider a Zalman cooler to go with it, but it's up to you.
All in all, my X800 has served me very well, and exceeded my expectations for it. Definately recommend it if you are short on money. I picked mine up off newegg for $142 with 2-day shipping (the actual card was $124, and that's USD by the way).
EDIT: My good friend has a 7600GT, and he can run BF2 same settings as me, with no problem. The 7600GT and the X800GTO are PRETTY MUCH on-par with performance. The 7600GT is slightly better, but nothing too-too drastic.
Good luck on your purchase!