There is no perfect college, but many (most?) students have much more positive experience than the one you are having. Without knowing your budget, it’s hard to suggest colleges.
In hearing you talk about your current school, it makes me think back to my own experience at a midwestern flagship. I was in the honors college and found many of my types of people (and discussion classes) there. But I happened to make good friends with one of the students who was given one of a limited, competitive number of full-ride scholarships. And through that student, a large portion of our mutual friend group was from that pool of students. There were people in that full scholarship program who went Greek and had a work hard/party hard attitude, with more of the stereotypical Animal House style of parties in mind. But the majority of the others were definitely not that way, and they enjoyed game nights, nights at the theater, and also going to sporting events. But fun/entertainment did not resolve around alcohol, if that’s where your concern lies.
All of that to say, see if you can find just one person who is your type of person. Maybe it’s someone is in one of your honors classes, or one of the people on the newspaper staff who’s exasperated by the procrastinators, or someone at an event in your living learning college or an event hosted by your honors college. If someone sounds interesting in a discussion, start talking to them afterwards. See if they want to grab a coffee or eat lunch or whatever. Once you find one person, I think it will be easier for you to find more (and that one person may already have a simpatico circle that you would really enjoy).