Why do neighbourhood pages usually fail?
Because they are one page rewritten with the place name swapped, and that is a pattern search engines have been filtering for a very long time.
The standard version takes a services page and produces one copy per area, changing a noun. "Plumber in Tuscany", "Plumber in Mahogany", "Plumber in Bridgeland" — same paragraphs, same headings, same photos. There is nothing on any of them that could only have been written about that place.
Two things go wrong. The pages themselves rarely rank, because there is no reason to prefer any of them. And they drag: a site whose page count is mostly thin duplicates is a weaker site overall, so the pages that were working have to carry them.
The tell is simple and worth applying to your own drafts. If you could swap the place name and the page would still be accurate, it should not be a separate page.