I've only worked with a few hundred boxes at a time, but I've never had a failure on a hardware array from a single disk. I've never seen it on external DAS arrays, on SAN arrays, or on NAS arrays either. I would be interested in what kind of adapter was the root culprit, and if there was some hardware problems with it.
Linux seems to offer better flexibility in the options you get for software RAID. With a combination in hardware options with software tuning over it, allows the end SA to do some very granular configuration that isn't available in the Windows environment, yet.
Hardware is more than just battery backed cache, you are missing the entire point of running parity based RAID on hardware. The XOR processor. For particular hardware, housing a DAS array, if you are pounding the machine with system calls and passing massive amount of IO the machine will choke trying to process both. You add the hardware based solution, and offload the parity calculations to the XOR processor you can actually have a functioning box.
As far as I know the logical disk manager for windows is a Veritas joint venture product. Which means that a third party is always involved with LDM operations.