Have you thought about relocating?
Not sure how things are in the States right now but here in Canada good people are hard to find in the tourist areas such as Banff in Alberta for people with experience in the Hospitality industry.
Although I don't know for sure I would think the same would be true for New York although I know the cost of living there is through the roof.
It is good that you realize drinking would only makes matters worse.
Keep the faith.