Fibre cables are not expensive, they are even cheaper than Cat6. Transceivers are a bit expensive, but got a lot cheaper than they used to be, still they are really cheap compared to other house build/remodel costs. The only issue is that you can't do power over fibre so it's inconvenient for putting wifi APs, cameras, and other powered devices.