You don't have to drink alcohol at bar. I have plenty of friends who don't consume alcohol, but have no problems going out and order non-alcoholic cocktail, juice, tea etc. Sure, it depends on a place a lot -- there are places where people go to chat and meet new people and there are places where people go to drink until passing out, so find the one that suits you..
I don't often drink, maybe twice a year and I've been given the advice you just gave the previous poster. The truth is drunk people are insufferable while sober I don't recommend anyone do this.
Well, as I said, it depends on a place. I usually go to places where people are going to play board games, pool, foosball etc. while getting few beers, not drink themselves unconsciously.
To each their own of course, but I find even mildly impaired people annoying. You don't realize how much an effect a few beers can have alcohol is deceptive that way, that's why you see people down a bottle of vodka and get behind the wheel. They honestly believe that they are fine to drive.
A tip if you do decide to try this advice, don't let anyone know you aren't drinking. Not only will you often get accosted "Come on buddy just one!", but at the end of the night you will often be pressured to become some sort of unpaid Uber.
I actually usually don't mind being a DD, only because keeping drunk drivers off the road is a net benefit to society. I usually don't have to go much out of my way either as nobody lives very far away. Of course, if I were expected to do this all the time I'd be annoyed.
For sure some people are extremely obnoxious when they drink, especially heavily, myself included (which is a reason I don't like getting drunk - I try to stay mildly buzzed if I do drink, but usually I don't at socal gatherings, unless they are major social gatherings, and I even usually only drink water at bars) but the vast majority of people are fine after a couple brews. Most people stop getting blasted at around 25 or so anyways.
Your attitude indicates to me that if your perception of someone changes when they've had a beer, just because they've had a beer, rather than their actual behavior. I don't mean to be rude when I say that - I can understand. I used to not be able to stand being around people when they were drinking. I avoided anywhere where I thought there may be alcohol... but that was because I grew up with an abusive alcoholic father and I was projecting my hatred of my father onto other people. It wasn't until years later I learned to be comfortable around social drinking. I learned to realize that my father did the things he did because he is a bad person, not because alcohol somehow forced him to.
As I said in another post, I actually ended up meeting the person I ended up marrying in a bar!
(I also did start drinking myself later on.)
To be clear I don't want to put you down or anything, just sharing my perspective.