There is a serious bug in the Linux mpi3mr driver for the following combo:
@ASUS Zen 4 host with SAS expander,
@Broadcom 9600-24i, and
@Seagate Exos 2X 14T drives. I don't have the time, resources, or patience to debug further. The culprit is 99.99%
@Broadcom drivers and/or firmware, where it can't even correctly handshake the drives. It will randomly fail SAS drive handshakes on boot/insertion. Key word is random.
Why do I think it's the mpi3mr driver? Because 9500-8i with mpt3sas works perfectly. I also tried like 6 different 9600-24i firmware versions to see where they botched things, and none worked.
Could also be a compatibility issue between the SAS expander firmware and the 9600 series. Again, 9500 with mpt3sas drives has zero issues.
Totally wasted my time. I had to eliminate the drives, power delivery, and firmware versions before finally giving up on the 9600 and replacing it with the old but trusty 9500.