28% of adults find it "impossible" to enjoy a holiday without alcohol, according to a new study.