Francois Tigeot did some testing of various hardware RAID adapters (Areca, LSI, 3ware, and Adaptec) in DragonFly, and reported thoroughly on each.  This may come as no surprise, but it sounds like Areca adapters are worth the money.

Update: There’s an updated mpt(4) driver, and the performance issues are fixed by enabling write caching.