You can get 15TB U.2 NVMe drives and use a PCIe U.2. adapter! Whether it fits in a SFF is going to depend on the specific chassis, but anything larger and it's fine.

You can also use an external PCIe Thunderbolt enclosure for macOS.