Red Hat 8 may actually work well enough for your purposes on nForce hardware.
The reverse-engineered nForce ethernet driver is in all recent 2.4 and 2.6 kernels. In fact, the funny thing is that once the open sorce driver clearly circumvented problems in NVidia's closed source driver, NVidia submitted huge patches. Oh the things companies do!
So if you're up to learning how to compile a custom kernel, the nForce should be just fine.