I have a friend who is a EJ guy. He hires and trains new advisors. He told me years ago that the door knocking works and if an advisor wasn't making $85000 his second year, they would ask him to leave.
I recently had the new local rep knock on my door one evening. It was just an introductory "How do you do?" with a request for approval to keep in touch. Very low key and not offensive in any way.
It works. It is a way to meet new people and it is not offensive.