Compared to what's out there now, it doesn't really amount to anything. I have one in my second computer (the one I do emulation on) and it isn't bad. Can't say what'll happen trying to do DirectX9 stuff on it (never tried), but I can't see it crashing. Using the DircectX8 codepath seems likely, which means it'll run slower. I can definitely see a difference from my 6600GT though, but it'll still give you much more over your current card.
I got mine for about $25 though so it wasn't any loss. Oh, and Prafull, of course it's better than the 5700LE. The GeForce4 Ti is about equivelent to the FX5700 (not ultra, not LE) without the newer features. I'm unsure of speed, but it's a rough performance comparison. I think you were going by benchmarks, but performance isn't too different. On ATI's end, the 9600 is within the range of these two cards but it's definitely better, and it also has DirectX9 support.
My take? Get the cheapest of the three you can if you're budget limited. Your question was too broad though. Is it good in these days? Not really. Should you get it? That's up to you.