The following Seems to be lacking M-series drivers, but that is 'fixable' by the vendors ( Apple isn't particularly blocking this (hence working in macOS 13.x on Intel side .. just need to get past trying to do it with kernel extensions; that is a dead end. )
https://www.highpoint-tech.com/product-page/ssd7749e-311r1c
6-pin power in MP 2023. Check. Full length, dual width. Not a problem.
Drop the hardware RAID aspect and it would likely work 'out of the box' with standard Apple supplied NVMe drivers.
The 'hold up' here is likely trying to present as a non standard conforming drive.
For example 8x M.2 NVMe card works just fine in MP 2023
View videos, reviews and tech specs for Sonnet M.2 8x4 Silent Gen4 PCIe Card and determine hardware and OS compatibility.
www.sonnettech.com
U.2 drive no "hardware RAID layer" ... works.
View videos and tech specs for Fusion Dual U.2 SSD PCIe Card, and determine hardware and OS compatibility.
www.sonnettech.com
There is an entire thread on this
here, but the bottom line is nothing modern works.
The question is which of these work that are bootable. The sonnet works, but basically only with the Micron 9300 Pro drive. Other more modern drives do not work in the sonnet.
The problem persists for the HighPoint cards. They work, but only with older U.2 drives and a very limited number of them. Or if you marry multiple M.2 sticks, it works, but isn't bootable.
For example, the Micron 9400 Pro 30TB drive does not work with either of those cards.
There are other cards that let you piece together over 15TB using M.2 sticks, however, their problem is, while they will work and show up on macOS, they are not bootable (at least not pooled so the largest bootable drive you could have there is a JBOD single stick of 8TB).
Ergo, the problem is that something in macOS is incompatible with new U.2/U.3/EDSFF type drives, and seemingly purposefully so, and the last and largest single bootable SSD you can get is the 15tb Micron 9300 Pro (outside ancient spinning SATA drives). No other larger bootable SSDs exist for macOS. All these drives work with zero problems on the very same hardware booting into windows.
Apple borked support somehow. There are reports somewhere in that thread that some earlier versions of macOS specifically used to support more U.2 drives that are now incompatible.
It's a patchwork of randomness. For whatever reason, the Micron 9300 Pro continues to work, while other U.2 drives do not.
The current search on that thread is...are there any modern bootable U.2, U.3, EDSFF drives supported under macOS, and for months and months, if not years at this point, the answer has been a disheartening: nope.