Yeah, it's no surprise that I'm very interested in this. Sadly, my cynical self is telling me there's little to no chance of this getting a wide rollout.
There's so much to like. You can record up to 8 channels at once on that whole-home DVR, and store up to 500 hours of HD. I have a Tivo Elite with 4 tuners and 300 hours, and I'm still jealous
One of the coolest ideas I've read about this is one of those things that I can't believe hasn't been thought of already. Apparently when you add one of their TV boxes to another TV, it can create a WiFi hotspot to extend your wireless into that room of the house. This is a brilliant way to get WiFi coverage in a home. Naturally, we'll have to see how well this works and how easy it is to use, but if it updates all those hotspots automatically with any change in SSID, password, etc, that's pretty amazing.
As far as I can tell, there are two giant drawbacks to the Google Fiber service:
1) It's only in KC. I don't live anywhere near KC.
2) The TV service is missing some huge channels. ESPN, TNT, AMC, CNN, and some others (I couldn't care less about Fox News, sorry). That's a huge deal. It's understandable, seeing as ESPN is very expensive for these carriers, so that's probably why the price is so competitive with existing broadband services.