The good news (!) about the drug/alcohol activity at that intersection is that its mostly older folks who start their day off about mid-day, have cajoled, begged, or financed their way into their vice of choice by the late afternoon and are usually inside and settled by the late evening. While they do sometimes get rowdy, they seem to spend most of their energy yelling and arguing with one another over whose turn it is to go into the liquor store.
They don't strike me as the type to even think about wandering into a bar for a drink, and if they do, I suspect their choice would be Q's Tavern which seems to cater to the old man drinkers in the neighborhood. Like Tsarina said, they are more of the $5 Thunderbird and the $2.50 nip crowd and less of the cocktails and microbrew set. I don't think they'll even focus on whatever comes to that corner.