What probably would is something like having PCIe and USB to 1Gbps fiber adapters that cost $5.
I suspect the combination of the absence of cheap-o all-in-one AP/router combo boxes with any SFP+ cages and fiber cabling's reputation of being extremely fragile have much more to do with its scarcity at the extremely low end of networking gear than anything else.
[0] This is a two-port SFP+ PCI Express card
Anyone who talks about 25GBASE-T like it actually exists, doesn't know anything about what they're talking about.
40Gbase-T will never exist, sure. 25Gbase-T very likely will.
To be fair, the power consumption is also my biggest gripe with my WiFi 6 AP, they run extremely hot.
Heck, I don't even know what I should buy for 10G SFP+ ports and a distance of say 30 meters. Guess, I'm back to CAT6 :-)
If you learned what you need for 10GbT you can learn what you need for 10GbLR. Which is:
LC connector, PC or UPC, duplex, OS1 or OS2, and SFP+ modules saying "LR".
Any of the following is wrong: SC, FC, LSH, E2000, ST, APC, simplex, OM[1-5], "SR" or "ER" SFPs.
And that's short enough.
FS does custom multi-fiber cable assemblies too (beyond the duplex patches which is basically the standard), and they can also include pull eyes on them if that’d be helpful.
Single mode is a good choice, common wisdom used to be multimode for short runs but the single mode stuff is not much more expensive and the standard 10km optics will likely brute force the signal over any mistakes like cable kinks or dirt on the connectors.