Define when/where autofocus should be utilized

Follow up to gitlab-org/gitlab!21508 (comment 259295559)

There are instances where we can utilize autofocus to improve the experience. We should document some guidelines to make it easier to know when and where autofocus should be used.