As everyone else in the thread has said, it just sounds like you ran into the wrong people. It's no fault of yours, of course. Sometimes we're just unlucky when it comes to meeting new people. I myself find it very difficult to make friends with many of the people around me in real life, simply because they're not the types of people I want to hang out with. I go to a very... preppy university. In spite of the university boasting about how diverse and multicultural the student body is, much of it is very homogenous. Many of the people here all act and dress similarly to one another. Everyone is either a rich prep that's super involved in campus activities and has gone to private schools their whole lives, or an overly-cynical hipster with an inflated ego and a pack of european cigarettes within arm's reach at all times. Many of them believe the only fun thing to do is get absolutely smashed at every opportunity.
I find it very difficult to fit in with these types of people, and often experience a vibe of hostility or disapproval from them, simply because I'm different. I don't come from a rich family, I'm not involved on campus at all, I'm not religious, I don't like getting drunk, and I just like different things than most of them. While they dress in skinny jeans, plaid shirts, and sunglasses, I come to school in army pants, a Godzilla T-shirt, and a tattered old hoodie. I suppose one of the few things I have in common with them is that I listen to a lot of music nobody's ever heard of—except my tastes consist mostly of very over-the-top electronic music and heavy metal.
The point is, you're not the only one who has found it difficult to fit in. Many furries are in the same boat, because we often have different mindsets and interests than most people. Again, your lack of acceptance into the fandom is likely the result of simply talking to the wrong furries.
As for the issue of drug and alcohol use, I believe Kibari put it quite well when they said that a person's use of these substances—or lack thereof—doesn't necessarily affect how they are as a person. For example, I do drink alcohol, but only in moderation; typically only a single drink every now and again. And I'm very picky about what I drink, usually limiting myself only to ciders and dark beers, with the occasional glass of wine. I'm of the mindset that enjoying the drink itself—its flavors, textures, scents, etc—is much more important than getting drunk. A friend of mine used a good analogy to describe alcohol: when used properly and in moderation, it's simply a social lubricant, so to speak. It can help one to relax and open up a little more to those they choose to spend their time with.
This brings me to my next point. This particular friend takes a few different varieties of recreational drugs. Some are fairly light, while others are quite hard. I wouldn't take any of these substances myself, but that doesn't change the fact that he's one of my closest friends. He's a genuinely great person, and he's never failed to be there when I need him.
By the same token, I've known drinkers and drug users who are just complete jerks. It really just depends on the person. You'll find good and bad people from every walk of life. What they do, and what they choose to put into their bodies is their decision, be it for better or for worse. But what you should pay attention to is, as Dr. King put it, "the content of [their] character."
As the others in this thread have said, we're all here to be your friends. You can speak to any of us without fear. This forum and its members pride ourselves on being accepting and representing the furry fandom properly. We put our best paw forward, so to speak. You're among friends here, and if anyone ever gives you any trouble, don't hesitate to let the mods know. They'll set things right.
You're gonna be just fine here.