For me the main problem of SO isn't even the moderation or human interaction. Even if a question is answered successfully, the entries have a short shelf life because modern APIs move and break so quickly. For example, I tried learning Ansible only through books and SO, and it was just frustrating. ansible_sudo_pass was deprecated for ansible_become_pass, but there are still many books and SO questions that still reference ansible_sudo_pass.
In the Good Old Days (or my rose-tinted memories of them), Java/C books and answers will always work even if it's not idiomatic, and JS/Python material might break once in a decade over a major migration like Python 2 to 3. Now I look at Ansible or Zig, copy a simple toy program from SO or GH, and just find that it doesn't work, because `sudo` became `become` and `fs` became `io`. There is simply no way for books or SO to keep up.