I did an extensive amount of both fiber and CAT6A in my recent house build, totally about 21 miles together. I did a mixture of single mode and multimode only because of some AV device support for multimode, and because all of it was so cheap compared to the labor and time.
I ended up with significant fiber runs between the MDF and IDF closets, the server room, and all of the AV endpoints which is a typical layout. I did run single mode fiber to all 18 wireless AP access-point locations, but I suspect those will not get used much given I also have 2 CAT6A shielded wires to each AP that can support 10G AND provided power. I do use a direct fiber connection in my office to provide 10G to my network core from that desktop, but that could have been done over copper as well.
Perhaps the biggest gain over copper is my switch interconnects which are 40G from the upstairs closet to the server room. If needed it would be easy to upgrade those to 100G, and since there are 24 strands available you really could expand as far as you are every going to need to go with WDM and the like.
The one really good use case for only fiber was running it down my driveway to our gate, which is about a 1/4 mile in distance. That is something that would be more challenging to do with copper. [although I do have copper installed].
From my perspective the cost of running fiber was almost 0 compared to the entire project because so much more cost is involved in path finding and clearing ( cutting holes, etc), and the actual pulling. I was very fortunate to have a large group of friends who spent a couple of days working with me to do the large pulls, combined with many weeks of evenings and weekends doing the rest myself. Many hands makes that task much much easier.
My particular build is documented in a build thread: https://www.garagejournal.com/forum/threads/jeffs-mountain-s...