It had enough good points to make the 5900XT pretty popular when it debuted for ~$200 with Call of Duty. This list of positives covers the whole NV3x range (well, except maybe the 5200
):
+faster 2D than ATi (according to Firingsquad)
+better multimon support than ATi (especially in Win2K)
+lower idle power usage than ATi thanks to dynamic clocking
+good "legacy" and DX8 performance (whether due to engines geared toward nV's 4x2 architecture, faster OGL drivers, or just incredible clock speeds)
+initially better (then worse, thanks to brilinear [and UT2K3]) AF than ATi
And, for devs (AFAIK):
+the chance to play with longer shaders and FP32 (way) ahead of time
Really, its biggest weakness was slow DX9 performance, a weakness exposed by 3DM03 and only evident in a handful of later titles (TR:AoD, Far Cry, ... um, I'm drawing a blank, but I guess there was the odd DX9 RTS). I'm not even sure HL2 is a real weakness, as apparently there's a DX8 water reflection hack that brings the FX's IQ just about up to DX9 level, and--
per Anand's DX8 numbers--at speeds pretty close to a 9700 (but, sadly, closer to a 9600XT).