I would think that compatibility should come down to the controller on the drive. There aren't really an awful lot of them now. Phison seem to be killing it.
I'm quite looking forward to bigger NVME drives becoming cheaper. They're certainly much less of a PITA than running cables everywhere. Hopefully with the new consoles using them they will become cheaper, given more should sell now.