Well the "theory" goes like this:
Natural selection only let the better/stronger survive. By continuously eliminating less performing brain cells, alcohol helps people having sharper brains

For mental illness and women, i'd search for burning out, hormonal disorders, abuse and the likes.