THIS THIS THIS.
I am studying Mechanical Engineering at CU and lived in the Engineering quad dorms last year and I would highly recommend it. It was overall a good experience because there is a mix of engineers and arts and sciences kids. Also, as mentioned in the above post, most of the engineers are normal and actually leave their computer/room (although there are always some cave dwellers). The people there are there to get their school shit done, but once it is done they like to have fun too (ski, party, workout, whatever). Pretty much just smart normal people who want a good degree and are willing to put the work in to get it.
I have heard from the very few normal kids who lived in Andrews say that the lives of many people who live there is run by magic the gathering card game, although I have never been in or seen the inside of the andrews dorms.
Aside from the dorms, I don't know much about the Engineering Honors Program, but the regular engineering program is plenty fucking hard enough if you are trying to ski and do other things along with school. In general, I would most say most A&S and business programs are a not too difficult at CU (aside from physics, chem, iphy, bio, accounting, a few others) but even the hard programs don't really compare to the engineering program, yes I have talked to people who have been in both programs (because they dropped out of engineering) and am not just speculating. I am not sure about A&S Honors, but I would guess that engineering is more difficult. If you are interested in doing something besides engineering though, by all means go for it and it will probably look better if you do it through the honors program, I just don't have any real experience in either honors program.
Boulder is a pretty sick place to live and CU is definitely the right school for me, I hope you like it as well and good luck with your decisions! Hope this helps and feel free to PM me if you have any other questions!