Its not about the tech, the negativity is due to the mismatch between hype and reality. LLMs are incredibly useful, for certain things, like the ones you have found. Others simply don't work.
Is it going to deliver on even 1% of the hype any time soon? Unlikely.