The ASUS P4P800 works fine with Nvidia, have used them before. If you have a Hyperthreading CPU and want to use the SMP kernel, you'll need to copy the driver the compiler makes for the uni processor kernel to the smp kernel directory should be okay after that. (there is a bug in the makefile) This is Redhat not too sure about suse or mandrake more than likely the same.
PS spelling bah! I'm in a rush