^^^^My D is at a small school (with a football team) and she does not find that sports teams dominate the school’s social scene. Maybe it depends on the school. That is why it is important to visit colleges Her college also has some Greek Life (not overwhelming) and she finds that all kinds of groups including friends, theater people, club sports, dorms, frats/sororities, as ell as sports teams. sponsor official and unofficial parties all the time. Her friends at school range from football players to students involved in theater and music.
Nonetheless, the point that the OP has to figure out what he/she wants in a college is the main jist of the response.