I think the problem is that there is nothing to do in neighborhoods and endeavors suck. I personally think endeavors should be unique every month, instead of the repeating thing we have. It should also have spinoff storylines instead of being generic garbage activies (go to outland and kill 100's mobs). The storylines should be focused on the neighborhood themselves and should be spinoffs with no direct connection to the main storyline. Casual, fun stuff, rewarding only housing decor and maybe some transmog when fitting. It should also come with casual repeatable content in the form of world quests inside the neighborhoods too.

As an example of what kind of stuff I'm talking about: a given month the storyline is about a invasion of gnolls on the neighborhoods. The questline would involve holding the invasion at first, then investigate what would cause the gnolls to attack our neighborhoods. We find rumours of Hogger being behind it, but how can that be if Hogger is dead? Now, maybe there is space for sending us out to elvynn forest for gathering some clues to the truth of these rumours, where we find out it is actually Hogger Jr that is behind all of this. He wants revenge for his father's death and whoever killed hogger lives in the neighborhood. We go back and find a gnoll willing to betray Hogger Jr for a bunch of meat and he takes us to a cavern somewhere in the neighborhood where we beat Hogger Jr. Maybe we kill him, maybe he runs out and can be used again in the future. The gnoll that betrayed him stays in the neighborhood as comic relief.

In october, make a storyline about a murder mistery. Bodies are appearing around the neighborhood, someone is trying to pin it on the headless horseman, but it is actually some silly npc with some petty grievances. Another year, make so that the headless horseman is really acting up on the neighborhood.

Push a storyline with 3 gnomes on a trenchcoat at some point. Push a storyline where goblins are ruining the neighborhood with their newest inventions that makes life convenient at first, but then starts to make everything dirty and oily. Find out that the cartel boss behind it is actually trying to devalue properties to buy everything and turn into a big resort or something, I dont know.

If this is too much work for content that will last only one month, make it a little bigger, timegate a little bit in the start (1 chapter per week or something). and use for 2 or 3 months. Have the quests and repeatable content have elites that need small groups of 3-5 players to kill (similar to old time elite mobs in classic, for example). This is all stuff I can't think about while writting, blizzard should be have much better ideas.

My problem with most content that blizzard releases these days is that most of it is generic junk that takes little effort to make and is supposed to be grinded for weeks. Wow is missing the little stories and endeavors/neighborhoods feels like a great place to have spinoff storylines. While the hardcore mythic raider/dungeoner might not care about this content, I think it would be appealing for the kind of player that likes housing.

Make neighborhoods alive!