Well, my observation is that schools where the general requirements have been reduced have allowed the majors to fill the space by upping their own requirements, whereas schools with more general requirements have fewer per-major requirements, so it seems to be a tradeoff. I personally greatly prefer the 2nd approach, e.g. Harvey Mudd has 1/3 general science/engineering core, 1/3 humanities/social-sciences, 1/3 your major. Contrast with many engineering schools, where your major takes up >2/3 of your courses, which I think is a rather oppressive way to do things.
It's possible there could be a school with fewer of both kinds of requirements, where students get a build-your-own-major sort of deal. But if we're going to choose between more general requirements or more per-major requirements, I greatly prefer the first: to me, the 2nd ("all CS majors must take systems, theory, databases, and 2 of the following 4 classes") is a lot more compulsive, and generally results in useless specialist classes being added based on who's politically powerful within the department.