Should one pick a college for its wholesomeness or for major strength

This may not be true in some subjects where departments at some generally reputable colleges may be small for various reasons (e.g. physics or computer science), where the faculty may not be numerous enough to offer the usual expected courses for the major on a regular basis, or cover all of the expected subareas of the major.

This does not mean that one has to attend a college that is top-whatever in the majors of interest, but choosing colleges to avoid those which are weak in the majors of interest makes sense.