Sorry for the being late to the thread. If this is a server for a production environment and/or is "mission critical" (i.e. for a business), using desktop hardware is a cheap and reckless way to get storage. The hardware isn't as high of quality and you are bound to run into problems with those sized arrays. This would be a much better option for a SAN. I don't have experience with SAN equipment and would not be able to give much more advice.
--------
If this is for personal use, you will probably want to get a RAID card (or HBA if you want to do software RAID) and use a SAS expander(s). The limiting factor in the number of drives you can run will be the case. You can run the RAID card and SAS expander on normal desktop hardware, which is actually what I'm doing in my file server right now. Specifically, I'm using a LSI 8708EM2 RAID card with the HP SAS expander. The case is a Norco 4020, which can house 21 hard drives without modification. I currently have 25 TB of raw spinning disk, split into two arrays (one with seven 1tb disks, and the other with nine 2tb disks).
The RAID card you choose isn't a big factor, except you will want to make sure it has the proper connectors (8087) and can work with "advanced format" hard drives (i.e. 4kb sectors).
Here is a link to the HP SAS expander.
http://www.storageforum.net/forum/showthread.php?t=8012
So, you could technically run 28 hard drives for every 8087 connector the card has. Again, the limitation comes down to storing the hard drives, rather than driving them. Theoretically speaking, you could run hundreds of drives off a single system. If you had a ton of money to drop, you could buy a bunch of rackmounted cases that can store a lot of drives and simply use external SAS (8088) connectors to the back of each case, which would drive a SAS expander and the drives.
With more details about the project, I think we could make better suggestions. Specifically, what this is for, what you expect of it, minimum requirements, etc. You seem to know most of these answers, already.