Using SFP+ modules for 10GbE is interesting, I deployed a full 10GbE network in my home connected by 5Gbit/s symmetric fiber from AT&T and a 1Gbit/s x 100mbit/s DOCSIS 3.1 connection from Spectrum as backup, I did this around August of last year and used UniFi/Ubiquiti for everything. Their new XG and XGS products all support 10GbE natively, without needing SFP+ modules to connect. I'm using the UDM Pro Max with an XGSPON ONU flashed with the community firmware from PON Wiki (see https://pon.wiki/category/att/ ) and the 2.5GbE port as my second WAN link to the Spectrum modem. I'm not doing any sort of bonding/load balancing, just failover so I'm almost always just using AT&T. There's a short DAC cable connecting the UDM Pro Max to a Switch Pro XG 24-POE which serves 10GbE to the rest of the house. The only SFP+ module involved is the XGSPON ONU. Most of the devices in the house connect to WiFi served by the UniFi U7 Pro XGS APs, which take 10GbE w/ POE and give off WiFi 7.

I pretty much always get at least 4600Mbit/s both directions over AT&T, and generally cap it out. Spectrum typically gives me at least 800Mbit/s down. The ISPs are definitely the bottleneck because neither provides dedicated infrastructure from each house to the CO, instead you have some sort of aggregation point which has a shared backhaul and that means you compete for resources, but having the largest plan on each at least gives you traffic priority.

Realistically, I don't need any of this, I was doing just fine with normal gigabit fiber with a 2.5GbE network before I moved last year, but it's nice knowing everything is as fast as possible in my path and that eliminates congestion and local network resource contentions as causes when a problem arises, I know it's pretty much always upstream of me somewhere.