If you can get true fiber (not "our cable network hooks up to fiber, so it's really like the same thing) such as Google or AT&T, do it. While it's always possible that back infrastructure (all the junk back at company headquarters where it ties to a backbone and other network-y things) diminishes the experience, you're always better off starting with a solidly implemented fiber line all the way to your wall.
I have AT&T fiber. I'm running it in "bridge" mode, which means that the fiber optic cable terminates inside my house into a box that AT&T provides. That box then outputs an RJ45 port (ethernet, for ease of conversation). Essentially, that port is a 1Gbps Up /1 Gbps down network connection.
I run my own boutique network gear throughout the house, but the relevant information I can give you is that I've had AT&T fiber for 2 years. I've lost connection twice - once when the City of Waco dug up a cable bundle accidentally, and once when I relocated the box onto a new UPS. No matter what time of day or day of the week, the throughput constantly tests within 95% of the maximum values expected from the relevant hardware.
My wife largely operates her law practice from the house, including mostly Zoom meetings. Since I'll get called back screaming from wherever I am if it it fails, my network has to be as bulletproof as possible.
All that to say, yes, I'd pounce on Google Fiber if the choice were that or non-fiber networking.