Sometimes they can serve as a useful intake system for collecting information before passing someone off to an agent, but even then they tend to be less useful than just filling in a form. I think in most cases, a step by step form followed by a live chat would be better.
Unfortunately there is a segment of the population that is completely incapable of filling in a form. These people should probably be passed off to human beings, but then those human beings are wasting their time dealing with similar issues constantly.
LLM chatbots are even worse. They have great latitude to say convincing and incorrect information, but can rarely actually do anything. It would be much better to just publish a good knowledge base.
I would say a pet peeve of mine is when you do end up having support staff that are human beings, but are not empowered/trained to actually solve customer problems sufficiently. From a business perspective a chatbot is a great replacement for that, because it also regurgitates a script without actually having to action any business processes.