Grind, it sounds like you are a younger guy and I can sympathize with the experience of alcohol providing that "liquid courage" in social situations, at parties, bars, etc. However, like you, I came to realize that false sense of courage really just turned me into a total jackass, and a dangerous one at that.
As far as women, believe me, they are much more attracted to an articulate, confident, personable man than an out-out-control drunken "party guy." I also found that during my 20s and 30s, I naturally became much more comfortable "in my own skin."
And now with some sobriety, I find myself much more personable in day to day interactions because (1) I am not hungover and miserable, (2) I am not drunk and out of control, and (3) quite simply, I feel good about myself.
You may surprise yourself too with how adept you can be socially without the booze!