I live in a completely different milieu (Australia), where halfway houses are rare, simply because they're rarely needed. There's no doubt that aftercare is needed for released prisoners and folk discharged from other institutions. We regard this as the responsibility of their families and the communities from which they came. The slack is picked up mostly by faith-based organisations. The Society of Saint Vincent de Paul, The Brotherhood of Saint Lawrence, and the Brown Sisters are the main players in this field. But most folk agree that congregating ex-offenders (even a few) in a single location is a REALLY BAD IDEA. Housing is found, and drop-in services are provided to people where they live.
Our system works well, mostly because the majority of parole/probation officers are unpaid volunteers, usually nominatated by their Church, and so are not driven by arbitrary performance indicators.

But to deal with the nub of the question - would I want a halfway house in my neighbourhood? Yes! I live in a gentrified middle-class area, and I feel ex-offenders give colour to the neighbourhood, and a pool of folk more likely to volunteer for community causes.