Universities are actually conglomerations of various schools and colleges. Most of the larger ones have multiple campuses that are often miles apart, so it's something of a misnomer to speak of "college" in generalities.
Your experience will vary drastically depending upon your field of study and I can assure you that there are plenty of conservative students attending.
If social sciences are not your cup of tea, go to a school of engineering instead.