Anything with a bit of judgment call about the kind of site you want returned is really bad, imo. Say I asked someone to search for blackberry-pie recipes, but specified I only wanted recipes from individuals, e.g. stuff posted on personal/university/etc. websites, not on content farms, TV cooking shows' websites, aggregators, etc. A human could trawl through a few dozen pages of results and pull out some recipes, but afaik there's no search term on Google that will do that.
It's also bad at summarizing information. I can get a scattered set of results for lots of topics, but it can't synthesize those results into a nice executive-summary paragraph for me. Never mind even better summarization, like searching for a topic that has no Wikipedia article yet, and having Google's algorithms write the article for me to read!