Firstly, the difference that may or may not be heard changing between copper, fibre and wifi seems to depend alot on how revealing your sound system is, how low the noise floor is, and how noise each network device generates. I am quite sure the noise that a network device experiences (input and self generated) affects its performance and 'somehow' can affects sound quality. This is based on heaps of experimenting with a range of audiophile and generic network devices, cables and tweaks.
I am quite sure coax internet service will most likely transmit more noise into your devices than fibre, far more than the SFP module. The first device (optical termination) may add noise to effrct8ve reduce the benefit of fibre.
Then, your network devices add more noise baxk,such as switches and Fibre media converters can add noise back. Then cables collect some noise and transmit it in your network. Network isolation transformers (in switches, routers) seem to do little to block noise, fibre seems to block more. In my experience, it is worthwhile trying to optimise every device, power supply and connection (cable, etc) in the network, especially in the direct route from internet to streamer. It can be costly so try to keep perspective and commensurate with the calibre of your other gear.
I have fibre optic internet service, SFP+ router, fibre, and finally wifi connection to Mt Devialet ... so I'm not an advocate for any particular medium, moreso an advocate to use whatever gives the best value solution for each connection.
Fibre is great value for long runs where $1k per metre for audiophile cable is not feasible/good value.