Three variants of Magic-SFP MOCA adapters aren't mentioned in the list, all from MDSLink:
1a. Upper band with 1Gbps SFP
1b. Upper band with 2.5Gbps SFP
2. Lower band with 1Gbps SFP
Only #1 variants are compatible with OTA sharing the same coax, since OTA will use part of the lower band.
#1b...
The 2.5G variant is being sold now.
https://www.streakwave.com/mdslink-mgc-25-h-magic-sfp-moca-sfp-25gb-high
It works on my Mikrotik CRS309 with ROS 7.12.1, but not RB4011.
Auto-negotiation has to be disabled. The ROM has some typo and the model number (1.0-H) on the box and SFP module were...
I looked deeper at some of the presentation material.
Looks like the Magic-SFP uses Moca Access, whereas typical consumer devices use Moca Home.
That would explain why the transceiver RF band starts from 400MHz. It might not be compatible with typical consumer adapters.
FYI, the Magic-SFP transceivers are now on sale for $125.
https://swginc.com/product/magic-sfp-solving-the-last-mile-bandwidth-challenge/
From my last exchange with SWG, they mentioned the adapter will only be able to do 1G with Mikrotik routers. I suspect that is due to the typical SFP+...