I highly doubt anyones Zaydes, or Rebbes, got so drunk to the point where they were puking their guts out and were a danger to themselves and those around them. The “famous posek” you reffer to, I doubt he was barfing all over the table and I highly doubt he gave his haskama to those who did so as well. Moreover, if he felt that the drinking done around him had nothing to do with ad dlo yada and everything to do with “having a good time” I am 100% certain he would have told those people to stop drinking.
Lastly, it is very easy to quote “famous posking”, “great roshei yeshiva” and “prominent rabbonim”. We all can. It is a completely unverifiable claim. Name names. Who said what tpo whom and when. Rav Shmuel Kamenetzky has been quoted as advocating the exact opposite of what you are. Please name a contemporary Rav or Rosh Yeshiva who disagrees with him. Rav Shmuel knows the Rambam and all the sources you cite and he STILL said what he did, are you saying he is at odds with them? He doesn’t know of them or understand them? For your “argument” to have any validity (in my eyes) please provide a name.