I don't know if it will matter to Linux what hardware you are using. Normally not the bleeding edge is best, I know Nforce4 works well out of the box with Nvidia 6x00s, 5x00 series video cards. Don't forget you also have IDE drives to work with.
I have 2 similar setups here now.
1) Chaintech VNF4 Ultra, AMD64 3000, 1GB, with a little 40GB IDE for the file system, 4 Hitachi SataII 160s in soft RAID5, Ubuntu Dapper 64. Nothing, including kernel updates, seem to bother it, although I wait about a week before installing major upgrades. I have used this everyday for over a year flawlessly.
2) Tyan 2882D dual Opteron 246s running CentOS in a similar setup, but with 250GB drives.
Good controllers are expensive and If they fail they might take the RAID with them. If you have multiple PCs, and want to spend some extra money, get a decent gigabit switch to connect them. You will double throughput of 10/100. This comes in handy copying LOTS o' files between computers when upgrading/changing hardware or the OS on various PCs in the "farm". If you have Microsoft computers set up Samba for file sharing a public folder, it works for me. Drag and drop from Linux or WinBlows.
My WinXP box is currently a Gigabyte VIA board AMD 1600 I built 6 years ago, soon to be replaced by a virtual machine hopefully. If you don't abuse stuff, it should last longer than you'll ever need it to last. I had some old socket 7 stuff and replaced the pentium 200MMX with a K6-2 last year for fun. I gave it to someone with a lite version of Linix installed. It was as plenty fast enough to surf and read email. You'd be suprised what will run on very little hardware with Linux and you don't even need a Vi$ta tool to tell you if it is adequate.
So many computers, so little time.