If I decided to end up going for a Mac Pro with pure speed, I would want to fill it with 4 SAS drives. I've heard that SAS drives are completely unrivaled in speed (15,000 rpm

), but does this really correlate to high speeds? Is Apple's RAID card the best solution for SAS drives? I would likely use RAID 5 setup for striping benefits as well as data redundancy.
Generally speaking, they are fast. But you have to keep in mind the usage (workstation or server) to choose the best for your needs. For example, Fujitsu makes wonderful workstation drives, due to exceptional random access speeds, while the Seagate Cheetah 15K.6 drives, while technically the fastest SAS drives out there, are better at server applications. (Large file transfers).
You might want to consider the Velociraptor 300GB drives, as they are also very quick. Like SAS, it's more expensive per gigabyte, and the capacities are smaller.
If you need capacity, there are SAS drives available, but they are slower. Cost wise, and the fact you are using RAID to improve speed, you might be better served with SATA drives. (Keep in mind, I'm referring to enterprise drives, not consumer, as they really aren't up to the task of RAID, especially where reliability is concerned).
I presume you're aware of the issues with RAID 5 (write hole issue). If not, there's a description of it in Wiki. Definitely worth reading. If you do go this route, just make sure to keep the array size down. A max of 4 drives will help with this.
Now, I'm a bit of a storage junkie, and SAS drives won't be a viable storage solution for everything I have already (and even more in the future), so external storage would be a must. I have a drobo already, and it is a much cheaper solution than getting something like an Xserve RAID, and firewire 800 is plenty fast for streaming video, even to multiple sources. My question is what will happen if I hook up 4, 5, or even 6 drobos? How does daisy-chaining many storage solutions affect speed? I won't be buying a Mac Pro until the next generation, and I'm assuming that there will be 2 firewire 800 ports, but will this even be much of an advantage? How about RAID striping across chained firewire?
Hope all these questions can be answered.
Daisy chaining will slow you down, as the bandwidth is shared. Internally, the drives are switched in the Drobo, so only one drive would be read/written at a time.
Another possibility would be to use a RAID card that has the ability to run both internal and external drives. You can even use an internal only, and use a special cable, (I can provide info where to get them if needed), to run from the internal port(s) out an open PCIe slot (cover), and run the other end to an external enclosure. Just don't span an array between internal and external drives. Way more hassle than it's worth (recovery issues, particularly in regards to power faults).
Areca makes some really good SAS cards, and are hands down better than Apple's offering. I'd recommend looking seriously at the ARC-1680 series. Great features, particularly the backups of the Partition Tables. You can also upgrade the memory on it. It boots. Many more.
They also have an external 4 port MiniSAS connector (SFF-8088). This cable is easy to find. You can attach 4 additional drives to an external enclosure. Any more, and you need a SAS expander, and those aren't cheap.
why dont you fill it with 4 SSDs in a RAID setup instead
SSD's aren't exactly the most mature products yet. Capacities are very small, and they're still quite expensive.
Personally, I still have some concerns with the reliability. MLC and SLC just don't have adequate write cycles yet, IMO. Even with write leveling, and a couple of other tricks to aid in extending the useful life of the drives.
Further, current OS's are still optimized for mechanical drives. This is problematic, as it can fragment, and even prematurely kill an SSD.
This will change, but I think it's worth waiting for more data, and possibly some advances yet to be seen. FeRAM is one of them. 1E16 write cycles vs. 10k or 100K of the current Flash technologies.