It is indeed ironic. And if I have ever recommended LSI cards (hint: I do that ALL THE TIME, because they are objectively so good), I apologize to everyone who has been hit with similar ironic problems.The irony, considering how much headache the LSI boards gave me in the end. Not sure the onboard CPU is that beneficial if you are just using it as a HBA, it isn't like it has much calculation to do. All of the heavy lifting is done on the main CPU, which nowadays is very powerful.
In my experience (which is now ~10 years old), even in non-RAID mode the LSI device driver and their interface data model is very efficient in using CPU and memory bus resources. They can handle extremely intense workloads (thousands of outstanding big IOs per card) without bugs and efficiently. We spent considerable time tuning around it. But if they are broken, none of that helps.