The higher tiers on Internet service have an appalling cost. You can get lots of bandwidth on FIOS or on Comcast here in Richmond, but you're looking at hundreds of dollars a month. Never mind that the FIOS infrastructure, at least, can handle hundreds of megabits per customer, they're going to continue to charge for bandwidth like it's going out of style.
Plus, even with the decent connection at work, I've run into lots of network congestion issues that keep you from using that bandwidth - literally the only times I've ever been able to saturate our downstream Internet connection is using Bittorrent to pull down Linux ISOs. Everything else is choked off, and we've only got a 20/7 connection.
Now, one of the things about the Google Fiber services is that it's all DHCP right now. There's restrictions on running servers in the service agreement, so there's perilously little you could do to saturate that link (short of Bittorrent to other people on your network), but what it does do is remove a major chokepoint for neighborhood-level networking.
However, there are good things. Offsite backups become retarded-simple, since you are now limited by the streaming capacity of your hard drives. Since you're guaranteed to have a top-notch connection to Youtube, HD videos should play much more reliably. Video conferencing. High speed VPNs to the Amazon VPC infrastructure. The list goes on.