All my drives, both OS and storage sit on an Areca card. I do not have a BBU at the moment as I am ok with that risk. Storage is on HDD, OS on SSD. A BBU in this case really wouldn't make that much difference based on the above.
That said, what I would like to see, is a BBU for each drive, in particular for a desktop solution. Given they're 2.5" now, there's plenty of room available for adding a thin, 12v battery stacked on top of the thing. It should be possible to package them neatly, and relatively cheaply. Unfortunately that doesn't address the laptop market so much, but given power loss is a much lesser risk, I think that may be a moot point.
That said, a proper controller with a BBU combined with the above isn't unfeasible and realistically should be used as a last resort if your UPS fails, or for a safeguard for those that don't run a UPS.