I used Nvidia cards for a long time with great results, but the last machine I built I decided to try a an Ati Radeon HD6870, also with great results whether I used the opensource driver or the proprietary Ati driver
(Though I will say I had to play around a bit to get the dual monitor setup working properly on Arch linux, not so with OpenSuse)
Since then the Nvidia card in one of my other machines died a death so I replaced it with a Radeon HD6770 and got much the same results. Both machines are on 64-bit operating systems, and both cards have DDR5 memory
Having said that, don’t know what board yours has but it looks like it has an onboard Geforce 6 so I’d be inclined to stick with an nvidia card, I seem to remember a fair number of boards with onboard Geforce’s from around that time running on nforce chipsets and it could be you’d have less chance of issues if it was kept ‘all nvidia’
As for compatibility, much depends what type of pci-e slot your motherboard has, the onboard geforce 6 you have is pretty old spec so it could be quite an old board, pci-e 2.0 is from around 2007 while Geforce 6’s were around a few years before that but were still used as onboard cards at least until geforce 8’s were available if IIRC, maybe longer so it’s hard to guess what pci-e you have, the motherboard manual or bios should tell you if it isn’t marked on the board itself
However, don’t panic if your pci-e is earlier than 2.0, cards made for pci-e 2.0 slots are backwards compatible with the earlier pci-e 1.x slots, they just won’t run as quickly as if they are plugged into a pci-e 2.0 slot
Cards made for pci-e 2.1 slots though won’t work on pci-e 1.x boards though, but should on pci-e 2.0 boards
(Most of that compatibility stuff btw is from my own experiences and observations from buying parts for and working on a plethora of old to new machines rather than being some all-knowing completely up-to-the-minute hardware guru)
Hope that helps
BTW … Might also be time to upgrade that 300w psu, I remember having a win 98 machine with a 400w, but it was considered hi-spec then along with it’s ‘massive’ 13 gig hdd and ‘huge’ 512mb of 133mhz sdram!