I attended a large state U and while there were definitely lots of parties, I don’t know anyone who felt the need to party all of the time. I went to visit HS friends at their colleges, I went with roommates to visit their HS friends and their colleges, I visited boyfriends’ sisters and their colleges, all large and small and parties to be found at all of them. I have a friend who went (and graduated from) Liberty University and managed to find the party scene. If you can party there, you can party anywhere.
I do wonder what people think when they choose (or don’t choose) a college based on its party reputation only to discover that it doesn’t live up to expectations.