For me only the case of inability to reassemble RAID array on different server (with different controller or even without it) for data recovery shouts a big “NO” to any RAID controller at home lab.

While it is fun to have “industrial grade” thing, it isn’t fun to recover data from such arrays. Also, ZFS is a very good filesystem (imagine having 4.8 TB of data on 4 TB mirrored RAID. This is my case with zstd compression), but it isn’t playing well with RAID controllers. You’ll experience slowdowns and frequent data corruption.