Hardware compatibility is very hard to find out, unless there's been a lot of problems with certain combination. Which is not quite the case with Radeon and Audigy problems.
As you can figure out from the Rage3D's motherboard list posted above, most can run the system fine, while some has problems. You don't know whether it will work like a dream or like a hell, not until you try it yourself. Don't forget that you have the right to return hardware that does not work.
It is true that nForce mobos have had some problems, but there is no perfect chipsets, is there? They all have their problems, seriousness is defined by how much attention the problem gets.
Ice, the best place for looking specs of certain motherboard is to look at the official site. Having SATA in your mobo does not mean that you can't use ATA devices. Most SATA mobos can have 2 or 4 SATA and 4 ATA devices. In short, you can use four IDE devices, all your hdd's and cd-/dvd-drives, while having an ability to add SATA devices later on.
Motherboard is the most important single hardware in your puter, get the best possible mobo and you're set for almost any future upgrades.
Since AMD is now increasing their CPU prices, I'd recommend to look for Intel 875P mobos and new 800MHz FSB P4's. May take a while until those new P4's are fully working and available. Good thing the flaw in new P4's was discovered before they ended up to any customer's hands.
You're digging your own virtual grave when trying to figure our all incompatibility problems people have reported. Just concentrate on well reported, investigated and serious problems.