There are people doing drugs on the street in every major city. If that bothers you stay in the suburbs. Chestnut street is a pretty sleepy enclave compared to other parts of the city. Regardless I live in the Mission and it is great and thriving.