I actually decided I was drinking too much at that job so when I quit I took a break from drinking. One of the jobs I interviewed with had their happy hour as part of the interview! It's an insane "culture fit" test because of the many valid reasons you mentioned people might not be comfortable with it.
Like you said, people can go drink with their bros. Good not to tie your social life to work anyway so you can leave without losing all your friends.
I think putting beer out for an hour or two at an event and having a culture of 1-2 drinks sporadically is fine. But I'm avoiding any employers with a keg in their office, beer in the fridge every day, a happy hour culture etc.