clarify chap-sha1 and md5 default usage in various docs sections

---

• Close #262 (closed)
• Changes should be cherry-picked to 24.2: yes
• Staging: https://docs.binary.picodata.io/picodata/at/chap-sha1_md5/