I used to have a GForce 040 in my 2000 (motherboard rev 6.2). It worked very well with OS3.9BB2 (kickstart 3.1). I also used a CV64/3D, a Delfina Lite and a Multiface IO card. Everything worked very well. I don't know what was the revision of the rom though.
The only drawback I see is that the ram modules are expensive and hard to get. On my GForce 040, I had 16Mb of RAM. With OS3.9 and Picasso96 (that took away 4Mb for the CV64/3D), it left me only 11Mb after booting. It is not that much if you intend to do some internet surfing, playing MP3 or viewing images.