HUGE difference between bars and clubs. Who doesn't go to bars- my dad and my gramps still do.
And asking this in a tech forum is going to bound in a circlejerk.
During my clubbing days (which wasn't much), my brush with such douchebags and drunken retards were always minimal.
Where do you guys go? You gotta go to places that are semi-classy and require proper dress 21+. Not 18+ trashy places by the beach like the ones in Jersey Shore show.
The troublemakers are rare or just simply avoid them. Most are friendly and have a good time.
I went through my clubbing days in a military town, so after a few close calls I learned who to stay away from and when it was time to move to another bar/club; for the most part if you don't act the fool then you'll be left alone. I've only gotten into one confrontation at a club, and that was me walking up behind the girl I was with and giving the drunk guy who was putting his hands all over her the "Back the **** off." look as I helped her put on her jacket. He was about to get in my face when his (mostly) sober friend grabbed him and brought him back to the bar.
90% of fights can be avoided by knowing when to let it go, and the other 9% by standing your ground when you need to. For the last 1% that you can't avoid? Just know that a bouncer doesn't care who started the fight or who was in the right... Both of you will kiss the curb.
I stopped going to techno/hip-hop clubs years ago because these days (27) I just can't stand loud places where I have to fight for a place to sit. Now I just go to Martini/jazz/underground places where I can enjoy some good food and well made drinks while I get to know the regulars. I only go maybe once a week for happy hour, so paying $10-$15 for a well made drink isn't a big deal.
[edit]
...maybe you should stop being a doormat designated driver and go to have fun for yourself.

Fvck them you know? Life is too short to be so uptight and doing crap for others all the time.
I got over my shyness from traveling so much, and now I love going out by myself so I can go where I want and find new places. If there is a girl there worth talking to, she'll dig a guy that is comfortable enough with himself to go solo; you only look pathetic if you think/feel like you are. I got more numbers by myself than with any wing-man.