I have Google Homes in my house and I agree that after the initial feeling of huge usability it really doesn't achieve all that much. Chromecast integration is both wonderful and awful - I can say "OK Google, play <TV Show> on the living room TV" and it'll do exactly that... but if I want to pause it I have to talk over the show I'm currently watching.
All that said, I wonder what it would offer an elderly person. If my Grandma were still alive I'd be very tempted to rewire all her light switches to be wi-fi enabled and set them up with a Google Home/Alexa. I can see it being a huge, huge benefit to the old and frail.