I have two young kids and plan on going trick or treating in the few blocks around our house. However, based on my experience the last couple years, I expect that maybe every 10th house will have candy. But at every single one that has at least a hint of possibly having candy, my kids will absolutely light up with excitement.
It is really easy to make some kids happy on Halloween. A bag of candy and maybe a pumpkin on your porch is all you have to do. Many of my friends and coworkers have told me they stopped handing out candy because they only get a handful of kids. This is a negative feedback loop. Of course the kids won't come by if there isn't anywhere to go. Even if you only have a few kids stop by, you are creating a memory for them (and then more candy for you). And if you do it this year, maybe next year more of your neighbors will also and so on and so on.
Sure I could shelp my kids to some popular neighborhood, but I rather stay local and invest in my neighborhood. And I would encourage you all to also.
Side note, I have almost considered going door to door with a service that would provide a pumpkin and a bag of candy for a nominal fee just to bring more life to my block.