I haven't seen many cases of drunk passengers, but there are two that come to mind. Both were where booze was complimentary, once in domestic first and the second in international coach. One of these incidents was quite ugly where the passenger was ultimately refused more alcohol by the flight attendant, and he started verbally abusing the FA.

I don't think that any legislation is needed, but maybe some guidelines are needed on how to handle the (rare) problem cases.