I have multiple Linksys Managed Switches and multiple Smart Switches (similar to a Managed Switch without Layer 3 functionality or a console port). They mainly use traditional copper Ethernet cabling, but each has two SFP ports for fiber optics. In theory they can be used for any purpose, but in practice they are best reserved until the copper can cut through them. I use them for 30-40m runs around my house that go through the garage and end under the baseboards. The fiber is very thin, so it fits under the baseboard. The fiber is immune to crosstalk, so different traces stacked on top of each other do not interfere with each other. Another use, of course, is for very long runs or runs through an industrial area with a lot of magnetic interference or other problems. Finally, fiber optics don't conduct electricity, so there's no chaos if lightning strikes the connected device. In any case, these SFP modules are simply plug and play. I used Monoprice LC-to-LC fiber at both ends (in Linksys switches). Works perfectly.
MikroTik S+RJ10 Ethernet Transceiver
10 Review
π‘ CM19A R.F. PC Transceiver for X10 Devices
8 Review
10GBase-T SFP+ Transceivers, 10G Copper RJ-45 SFP+ CAT.6a, up to 30 meters, π Cisco SFP-10G-T-S Compatible, Ubiquiti UniFi UF-RJ45-10G Supported, Fortinet, Netgear, D-Link, Supermicro (Pack of 2)
9 Review
π‘ Izokee ESP-01 Serial WiFi Transceiver Module with USB Converter, Compatible with Arduino
8 Review
UGREEN USB 3.0 Ethernet Adapter Hub with RJ45: Fast Gigabit Ethernet Converter, 3 Ports USB 3.0 Hub Compatible for MacBook, iMac, Surface Pro, Chromebook, Laptop, PC
11 Review
π CERRXIAN RS232 to Ethernet Serial Device Server - TCP/IP Converter with 1Port DB9 RS232 Serial to Ethernet Connectivity
3 Review
π uni USB C Hub with Ethernet Adapter, 4K HDMI, Gigabit Ethernet, and 3 USB 3.0 Ports for MacBook Pro, iPad Pro, XPS
11 Review
π StarTech.com NETRS2321P: 1-Port RS232 to Ethernet IP Converter, Serial over IP Device Server - Black
5 Review