Yes ...
... for the MacPro. The drive scheme I recommend would be like this (I now dream my own system, if that´s ok):
- 320GB (stock configuration) Systemdisk for OSX and applications. A Western Digital Raptor/VelociRaptor with 10k rpm is good here, too.
- 1TB for general data/project files (two additional ones are possible via hidden internal SATA ports and mountable in the second optical drive bay)
- RAID 0 with Raptor/VelociRaptor drives (or cheaper with standard 7.2k rpm SATA drives of small sizes) for virtual memory/scratch and temporary data (only properly backed up one, of course). Chaining two drives in RAID 0 gives you roughly double the performance compared to one drive only. For scratch and virtual memory the more throughput you get, the better.
The data/project drive would be backed up, of course, to an external drive, too. You could buy Sonnets E2P or E4P PCI-Express eSata cards with port multiplier function. This gives you support for up to 10 (E2P) or 20 (E4P) drives, in supported enclosures. But you already mentionned that you got rid of an external enclosure. I propagate it anyways.
A recommended cheap but reliable drive casing would be Mapowers 2xSATA TB32 case with USB/eSata connections. You would use them with the two drives independantly (JBOD) mounted - so you could pack two 1TB drives in their, to backup your data/project HD and for other data stuff. If those drives are only mounted for backup purposes and otherwise off, you could get rid of the internal fan and make it really silent (it´s just screws and one connector, easily reattachable in case of warranty issues).
You can stuff additional drives into your MacPro, though. There are two additional SATA ports hidden on the logicboard. Use a PCI-Express SATA RAID card for more internal drives. I would choose any of the Highpoint Rocketraid 23xx/35xx series.
Here are all the links with information on the stuff I mentionned:
---
http://www.sonnettech.com/product/fusiond500p.html
http://www.sonnettech.com/product/tempo_sata_e4p.html
Sonnets 5-Bay storage tank. This would give you the maximum possible 5 drives per port multiplier. So with a E4P card and four of those you can go 20TB.
---
http://www.highpoint-tech.com/
Check the 35xx or 23xx series. This manufacturer is a top hardware RAID recommondation, in case you want to have it.
---
http://mapower.com/Product.asp?CateID=146&LineID=10
The Mapower case I mentionned. It says "USB only" for Macs, but that is definitely not true. In conjunction with the Sonnet E4P card which I am happily using with two of those cases.
---
http://www.xlr8yourmac.com/feedback/Mac_Pro_Ext_SATA_Case_Kit.html
The two internal SATA ports within the MacPro
---
http://www.westerndigital.com/de/products/products.asp?driveid=496
Two of the new VelociRaptor or two classic Raptors (cheaper, but louder and more power hungry).
---
For the data drives I´d choose Samsung drives: They are silent and fast.
---
The hack aka "enhancement" by your own feet:
http://forums.macosxhints.com/showthread.php?t=81586
Search for the posts by the user "E_James" (February 19th 2008). After installing properly, test it hard on project files before going productive.