I also have been following this thread with great interest and find myself inclining more to LCD's view than to ef83's.
I enjoy a drink whether on holiday or not and do not need a lecture on "what I have become" if I decide to have a glass of wine with my meal followed by coffee and cognac/whisky. So far no CC has found it necessary to comment on my behaviour.
I do however feel uncomfortable when sharing a flight with a group of rowdy pax and would prefer that CC take action to nip any loud behaviour in the bud.
It's always interesting to read how the professionals see their responsibilities with regard to pax behaviour and see it debated openly in the SLF thread.
It's equally interesting to note the difference in their attitudes to other thread contributors which vary from the polite to the downright sanctimonious.