yeah, it just depends on if your school actually enforces a DRY CAMPUS or not. i know some "Christina" universities that allow alchohol and sometimes smoking as long as you are of age. they see it more as a personal conviction, one that they should not have to worry about. Personally, i was thankful my undergraduate college enforced it. It was also nice having quite hours so i could study or go to sleep without stupid people keeping me awake. Well, sometimes the football player would be playing DOMINOES till 3 AM... ha ha, but they were nice and got quiet when i asked.
I went to a huge party school myself. The good thing was that it was so big that if your goal was to find a huge drunken party you could, but if you wanted sober friends, there were those too. I found them, mostly.
I remember one summer one of my classmates got caught with beer in his dorm room...he was also 30-something.
I go to a dry campus and I know they're pretty strict when it comes to drinking, even smoking on campus. It's a bit of a contrast since I was going to a regular university before transferring here. The school I went to was pretty liberal to say the least. The RAs weren't any better then some of the students they were housed with. Alcohol was pretty prevalent and I was first shocked when I saw the bottles in a friend's room from over the weekend.
In my opinion there is a simple solution to the drunkenness of rez life. Live off campus. It isn't that much more expensive, at least it isn't at my school, and that way you can get a place with friends who you know to be responsible, or who you care enough about that you don't mind seeing them act like idiots every now and then.