Since UND was brought up I'll give my 2 cents I guess.
I decided that I wanted to major in aviation becase I did not have a website like jetcareers to point out that it wasn't exactly necessary. By the time I found this place I was already so far along that changing things would mean that I'd be here (or somewhere else) for a loooong time.
If I were to do it over again I would go to somewhere like ATP or Skymates right out of high school. After that I would find a school in a more interesting place in the world and been a CFI throughout while majoring in something that would be a good backup plan for if I end up not being able to fly for some reason.
With that said, UND has been a good academic experience for me. The flying has been great, airplanes are in great shape, I have yet to have a bad instructor, and I've learned a whole lot. One of the reasons I didn't want to go to Riddle (other than the fact that its outrageously expensive) is that I wanted to go to a 'normal' college.
As was stated above, UND is a normal State School with many other programs that aren't even close to related to aviation. I've met a lot of really cool people that aren't aviation majors. As much as I love flying and airplanes, I dont need to talk about them all the time, so its nice to have some non-prop head friends around. We also have great sports teams which are very entertaining to watch (especially hockey). We have one of the nicest hockey arena's in the world (seats about 13,000 people and cost $90mil to build). The only things that I have absolutely hated about going to school here are the dining facilities (absolutely gross), the housing (but then again dorms anywhere are going to suck), and the fact that its in North Dakota.
While there is a bit of a drinking problem in GFK, its not everywhere, and if that's not your thing its pretty easy to avoid it. Dont believe everything you read, its definately a good idea that you're going to come here to check out the school, though I dont think you are doing it with a truely open mind.
Yeah, this is getting fairly long winded and pointless. So to sum it up. Has getting an aviation degree been good for me? Yes. Is UND a good place to do it? Yes. Would I do again, probably not.