What is the purpose of `autocomplete="off"` and when to avoid it?

It asks browser not to autofill, but often hurts UX. Prefer specific autocomplete tokens instead of blanket disabling.