What brands of hardware based RAID solutions have worked for you? Why?
Promise Fasttrack - it was cheap and supported Novell server 3.11. It worked very, very well over a few dozen servers.
What are your experiences?
For some time I also used a raid (striped) on my workstation and it was a beautiful, beautiful thing. Applications opened instantly. Compiles were immediate. Windows started faster.
Unfortunately I didn't want to spend the money on a RAID 10 (mirror on stripe - don't use RAID 01) and I didn't like the additional failure point of a second hard drive (either one could fail and my system is dead). The cost wasn't worth the extra speed, and the reliability of the cheap solution was to costly if it failed, and posed a greater risk than a single hard drive.
Why would you recommend against a RAID solution?
Only for cost and power consumption purposes. I would also recommend generally against RAID 5 - drives are cheap enough that if you've decided you need RAID, then 10 is the way to go.
Why would you use software over hardware based RAID?
Check out the ongoing discussion: RAID - software vs. hardware
A VERY worthwhile take on RAID 5 and RAID 10 vs RAID 01 should be mandatory reading before using any RAID setup:
http://miracleas.com/BAARF/RAID5_versus_RAID10.txt
-Adam