In theory, modern fiber is fantastic! You no longer need incredibly expensive tools and the cable itself isn't really any more expensive than Cat 8 (the current standard you should aim for if you don't already have a spool of Cat 6). It's also much more flexible than in the past and less fragile. There's still some big issues making it problematic for DIY home installation...
You gotta be careful and thoughtful. With something like Cat 6 or Cat 8 it's stiff enough that you can just push it through from above/below, go into an attic/crawl space and just tug on it. Yank that sucker! If it gets caught, push it back and yank again... It'll probably be fine! Even if it's not (you pulled too hard on a loop and kinked it), you can always just cut off that end of the cable or use a coupler and you won't lose much other than your time. Fiber isn't like that: You need to attach it to something like a solid metal cable snake while you fish it through a tight spot otherwise there's a good chance it can get caught and kink/break. Forget pushing it through from below something! It's just too floppy. You also shouldn't let it dangle! Be very careful and use proper screw-in or nail-in wall fasteners.
Very few things accept the various fiber cable connectors/standards. The modern solution to that is to wire your home switch-to-switch, using fiber as the back end connection between them. You buy switches with SFP/SFP+ ports and use fiber SFP adapters with your connector/standard of choice. This isn't really a problem per-se but it means that instead of "just" having a keystone outlet on the wall near the device-to-be-connected you'll have a little switch there and your device(s) will connect to that.
Aside: SFP is fantastic! It's absolutely awesome that even cheap, consumer switches have SFP ports now. Just bought a 2.5GBit ethernet switch for $50 the other day that had 4 2.5Gbit ports and 2 10GBit-capable SFP ports :thumbsup:
It's way too easy to break your fiber cable when you need to run something else alongside it. For this reason, when you're running your cables make sure you drill separate holes for all your fiber runs. Don't just shove it through the hole that already has your home's coaxial cables and other wires (e.g. phone, alarm, smoke detector wires). In fact, go the extra mile and install a grommet in any holes you drill (or just use some PVC/PEX/PTFE pipe/hose with couplers to prevent it from coming out) and WRITE WITH A SHARPIE on or near it, "FIBER ONLY!". Make it glaringly obvious that it's a bad idea to try running anything other than fiber through that hole.
Anecdote: A friend of mine ran fiber through their attic and an air conditioning repair technician stepped on it and broke it. Keep those wires up high and out of the way of possible accidents like that.