Paul is pretty clear about alcohol consumption in Romans. If you are drinking in front of a weaker brother that thinks it’s a sin, then you should not do it.
However, he says the same thing about eating meat.
So, weaker brothers leave us unable to live in freedom, though we can. Paul says it is permissible, but not always profitable.
So I do my drinking at home or when around non-believers. And being in a band that sometimes plays in bars, I may be in a bar but not drinking alcohol. Go where the sinners are. I have some very good discussions in some of those bars.
This “tyranny of the weaker brother” nonsense is part of the ongoing infantilization of Christian faith. In short it turns Christians like John MacArthur into Social Justice Warriors, always offended by anything they do not choose to do.