Where I do see it being handy is with mundane tasks or those "tip of my tongue" queries. I was doing some tedious mapping of enums to other enums today, and that's one of those problems where you can script it out in vim/sed, but then need to spend a while double checking it against the spec anyways. I'd love to ask a bot to do that for me. Similarly, the easy stuff like "how do I do [common git operation] again?", it seems to do great on, since there are canonical answers to that stuff.
I've been generally uninterested in the ChatGPT craze, but I did check out perplexity.ai when it popped up on HN a few days ago. It did seem genuinely useful for these types of queries, and it sources its answers with web links. I could see a space for that type of tool, as long as the hairier parts of the chatbot can be filtered away.