The 9800GTX suggested by the earlier poster is a great midrange card.
However, your CPU (3Ghz Pentium 4) is a bottleneck. The old Pentium 4 isn't fast enough to drive a 9800GTX to maximum framerates, so your performance won't be any better than less expensive options like the GeForce 9600GT or Radeon 4830.
Midrange and high-end video cards also require more power, your existing power supply might not be strong enough. You will also need more memory, so better to spend $80-$100 on your video card, and buy another 1GB of RAM.
If your power supply is 400W or larger, I recommend the Radeon 4830 or GeForce 9600GT. If your power supply is 350W or less, the Radeon 4670 is your best choice.
8GB 2x4GB Memory for Sun Blade X8440 240pin RAM ECC Registered DDR2 RDIMM New, 8GB 2x4GB RAM for Sun Blade T6300 Server 240pin Memory ECC Registered DDR2 RDIMM, 2GB 2x1GB Memory for Sun Blade 1500 2500 Upgrade ECC Registered DDR RDIMM RAM, 16GB 2x8GB Memory Upgrade RAM Compatible with Sun Blade x6275 X6270 X6275 ECC, HYNIX 1x 2GB DDR2 PC2-5300P VLP ECC REG SERVER MEMORY RAM IBM 39M5866 LS21 BLADE, Lot 28 IBM HS20 8678/8832 Memory RAM 1GB/512MB/256MB Blade PC2100/DDR333 CL 2.5, 1GB DDR2 DIMM for HP Blade Workstation Client RAM Memory 240pin New, 1GB Memory Upgrade RAM Compatible with HP Blade Workstation Workstation 240pin, 8GB 2x4GB Memory Compatible with Sun Blade X8440 Base Server 240pin RAM ECC, 8GB 2x4GB Memory for Sun Blade x8440 X6440 X6220 X8420 240pin RAM ECC Registered, 8GB 2x4GB Memory Compatible with Sun Blade x6220 x6240 x6440 x8420 240pin RAM, 4GB 2x2GB Memory Compatible with Sun Blade T6300 ECC Registered DDR2 RDIMM RAM, 4GB 2x2GB Memory Compatible with Sun Blade 1500 ECC Registered DDR RDIMM RAM, 16GB 2x8GB Memory for Sun Blade x6270 x6275 X6270 X6275 240pin RAM ECC, 1GB 240pin for HP Blade Workstation Client Upgrade Memory RAM DDR2 DIMM New, 1GB RAM Compatible with HP Blade Workstation Workstation 240pin Memory DDR2 DIMM, 8GB 2x 4gb DDR2 PC2-5300 RDIMM HP ProLiant BL2x220c G5 Server Blade Memory RAM, 4GB 2x 2GB DDR2 PC2-3200 ECC RDIMM IBM Blade Center JS21 Server Memory RAM, 1GB Kit (2x512MB) Memory RAM Upgrade for Compaq HP Proliant bc1000 blade, 16GB (2x8GB) Memory RAM for HP/Compaq ProLiant BL2x220c G5 Server Blade ECC Reg, 16GB (4x4GB) MEMORY RAM 4 HP ProLiant xw460c Blade Workstation DDR2 PC5300, 16GB (2x8GB) MEMORY RAM 4 HP/Compaq BL460c Server Blade PC5300 Fully Buffered, 16GB (4x4GB) Memory RAM for HP/Compaq ProLiant BL2x220c G5 Server Blade ECC Reg, 4GB 2x2GB RAM for Sun Blade SX2500 184pin Memory ECC Registered DDR RDIMM New, 8GB 2x4GB RAM Compatible with Sun Blade X6275 ECC Registered DDR3 RDIMM Memory, 4GB 2x2GB Memory RAM Compatible with Sun Blade X8450 240pin Fully Buffered DDR2, 4GB 2x2GB ECC Registered DDR RDIMM for Sun Blade SX1500 RAM Memory 184pin New, 8GB 2x4GB Memory Compatible with Sun Blade X6270 X6275 240pin RAM ECC Registered, 4GB 2x2GB RAM Compatible with Sun Blade 2500 184pin Memory ECC Registered DDR, 8GB 2x4GB Memory for Sun Blade x6275 X6270 X6275 ECC Registered DDR3 RDIMM RAM, 4GB 2x2GB RAM for Fujitsu PRIMERGY Blade ECC Registered DDR RDIMM Memory 184pin, 4GB 2x2GB Memory RAM Compatible with Sun Blade X6250 X6450 X8450 240pin Fully, 4GB 2x2GB 184pin for Sun Blade x8400 Memory RAM ECC Registered DDR RDIMM New, 4GB 2x2GB RAM for Sun Blade 1500 ECC Registered DDR RDIMM Memory 184pin New, 8GB 2x4GB Memory RAM Compatible with Sun Blade x6270 x6275 X6270 X6275 ECC, 4GB 2x2GB Memory RAM for Sun Blade 8000P ECC Registered DDR RDIMM 184pin New, 4GB 2x2GB ECC Registered DDR RDIMM for Sun Blade 8000 RAM Memory 184pin New, 16GB 2x8GB Memory Compatible with Sun Blade X8450 Fully Buffered DDR2 FBDIMM RAM, 8GB 2x4GB 240pin Compatible with Sun Blade x6450 x8450 X6250 X6450 Memory RAM, 8GB 2x4GB Memory for Sun Netra T5220 Blade AC T5440 X4250 240pin RAM Fully, 4GB 2x2GB Memory for Sun Blade X8440 240pin RAM ECC Registered DDR2 RDIMM New, 16GB 2x8GB Memory RAM for Sun Blade x6450 X6450 X8450 Fully Buffered DDR2 FBDIMM, 4GB 2x2GB 240pin Compatible with Sun Blade x6250 Memory RAM Fully Buffered DDR2, 8GB 2x4GB Fully Buffered DDR2 FBDIMM Compatible with Sun Blade x6250 RAM Memory, 16GB (4x4GB) MEMORY RAM 4 HP/Compaq BL460c Server Blade PC5300 Fully Buffered, 8GB (4x2GB) MEMORY RAM 4 HP/Compaq ProLiant BL20p G4 Server Blade Fully Buffered, 32GB (4x8GB) Memory RAM for HP/Compaq ProLiant BL465c Server Blade SERVER DDR2, 16GB (2x8GB) Memory RAM for HP/Compaq ProLiant BL465c Server Blade SERVER DDR2, 16GB (4x4GB) Memory RAM for HP/Compaq ProLiant BL465c Server Blade SERVER DDR2, 8GB (2x4GB) Memory RAM for HP/Compaq ProLiant BL465c Server Blade SERVER DDR2,