Keep in mind it won't work on Apple Silicon Macs though, and I think Intel Macs have limited support for nvidia cards in macOS

Hardwarewise or just macos? What if you want to add the GPU to a windows/linux VM?

To my understanding, it's just a lack of support from both macOS and third-party vendors. There are numerous other reports of successful usage in Bootcamp albeit with some caveats.

Regarding VMs, and this is hardware dependent due to IOMMU groups (and is based on a Linux host), but I also recall cases where this is possible on reddit.com/r/VFIO