The people I know who have actually done it wrote a personalized response as to why they wanted to live in that particular area.
i.e. "my son lives on X street and I would like to live by him" or "the access to hiking/biking trails is one of the things I cherish the most." , etc.
Otherwise, you are right that I think most of those letters are from Realtors and go immediately in the trash.