For laptops I assume you need USB/Thunderbolt adapters. (Still no SFP+ or SFP28 module for Framework?)
For desktops you'd use an SFP28 card (taking up a PCIe slot).
For devices like Raspberry Pi's, etc. you'd use... local RJ45 switches with optical uplink ports?
The convenience and flexibility of PoE would always push me towards copper wiring.
Most of my devices only need 1G or even 100Mbps. No reason to switch to fiber. 1G/2.5G copper ports don’t use that much power.
For 10G+ things, it’s fiber or DAC first if possible then RJ45 if it’s the only option.
Then my backhaul between rooms is just single mode fiber, good up to 800G. Plug in a small switch at the end and you go back to RJ45 and PoE.
I only have 10G though (to transfer large files/RAWs between my computer and my storage). Something faster would be nice because NVMe SSDs can go 50G+ but that equipment is pricey and power hungry.
Not even close to being true, unless you specifically mean 10Gbps over twisted pair (Cat6/7) cable. SFP+ is the default on a ton of network gear still.
Edit to add: If you want an example, these are the NVidia ConnectX nics available from FS.com, the lowest end one is 25g, then 100g, 200g etc.
We're at the point where 25GBaud PAM4 is being replaced by 50GBaud PAM4. That's 50 to 100 Gbit/s.
But iirc the use of PAM4 for the faster ones than "only" 25Gbit/s lanes is a hindrance to managing bottom-barrel price-per-bit. PCIe 3 was 8, PCIe4 was 16, and PCIe 5 is 32 GBaud with a line code basically like the 10+ Gbit/s Ethernet links (well, it's 66b/64b for Eth and 130b/128b for PCIe).