@lime2020, good question. Is the other school a small liberal arts school? If so my impression is they’re all pretty much the same.
My older son is a senior and he has a very active social life that mostly revolves around his good friends on campus that hang out together and do varied things. They go to school sporting events, especially to support their friends on teams. The school hosts events on the weekends for students (movies, speakers, comedians, etc.). There are clubs that host their own events such as concerts and plays.
There obviously is plenty of drinking on campus. My son didn’t drink when he went to college but he did start going to drinking parties, even freshman year. There are frats and sororities on campus (they don’t have houses though) that host parties but I’m pretty sure you have to be of legal drinking age to attend. Although I remember him saying he went freshman year so maybe they don’t always serve alcohol. My son says he doesn’t go to parties every weekend and the school’s social life doesn’t revolve around frats. There is The Little Pub on campus (https://hamilton.cafebonappetit.com/cafe/the-little-pub-2/), which is sort of like a sports pub (TVs, pool tables, electronic dart boards, dance floor, etc.).
There are also weekend trips planned by some of the clubs. Skiing, hiking, etc. There is a movie theater and a bowling alley in New Hartford that you can take the school jitney to.
My son says he always has something to do. Sometimes he says if nobody in his social circle feels like doing anything they just watch movies on Netflix in his room. If you have good friends you can have a good time doing anything.
Hamilton is not like a big state school. It’s not a party school. But if you’re looking at Hamilton I doubt that is important to your daughter. What does your daughter like to do? I can ask my son what someone with those interests might be interested in at Hamilton.