The Free Market Lie: Why Switzerland Has 25 Gbit Internet and America Doesn't
(sschueller.github.io)
Networking researcher here. Your bottleneck wouldn't be the NIC, but memory bandwidth, CPU compute (for TCP), PCIe bandwidth, and Storage bandwidth, also the bandwidth of the server you're connecting to. You'll also need some sort of fiber SFP connection for your entire house, and those have firmware that usually makes them vendor locked. Most networking issues are also latency related, so increasing your throughput to 25Gbps wouldn't help.
So yeah, not a good time for home use.