The card is not a bad one, but a well tweaked nVidia 6800LE will easily beat it - of course a 6800GT or Ultra would beat that too!
Sorry Dan, your right, it isn't "Bad" its Bloody awful !

Any Geforce 6600 or greater will benefit that system,but, not by very much at all.
Why? my current p4 2.6 800fsb cannot drive my 6800LE to its optimum - I'd need a 3.6p4 or the AMD equivalent to do that! - therefore, I would'nt expect the earth from a good card tied to a relatively old system.
I have a friend with a p4 1.8 (Overclocked to 2.4) 1024MB DDR 2100 & Geforce 6800LE, He scores about 5500 on 3D Mark 03, with the same card, I get around 9000, friends with faster CPU's get higher again - in other words, the cpu struggles to drive the card properly, this shows up as poor in-game performance.
6600GT's & 6800LE's are roughly the same price, I went for the LE and it runs very well on my system the same card is quite lame on my friends p4.
Imo, you'd be better off getting a second hand Geforce FX5900 from the likes of e-bay, pay next to nothing for it, in the mean while, save for a better CPU & Motherboard, and, more than likely, RAM
then you will be in a position to consider a Geforce 6 series card, otherwise, you will be quite dissapointed I fear.