It's always neighborhood dependent. We live in a kid-heavy town but trick-or-treating just sort of naturally condenses into certain streets/neighborhoods, and the town even shuts down Main Street for it. So the kids on your street might go to other neighborhoods to team up with friends, etc.
The only way to know is to ask neighbors who have been there for a while what the vibe is usually like on your street.
Our kid is 2 so tonight was his first time trick-or-treating. Our street always has some houses with candy but we went to a different neighborhood to go with friends. One of the houses we went to said they weren't prepared because in 20 years they've never had anyone come! They were excited to see people, though.