I’m gonna share my view from both sides. I made loads of friends from societies and clubs. These friends are amazing as we all share similar interests or enjoy the same activities. Had loads fun with them and went traveling all over the country for club trips and for uni/sports competitions. The point is that if you actively engage yourself into societies then you’d have no problem meeting actual interesting people who would love to hang out with you.
However, I did go through a lot of difficulties at the beginning especially during first year. During fresher’s week or even fresher’s month, almost all events organised in my flat and my hall involved heavy drinking and subsequent clubbing. I really made an effort to at least try a few. But honestly, I found it difficult to even talk to people properly (probs because of extremely loud music and drunk people...) let alone making friends who are genuinely interesting. It gets worse when later on people already formed small groups lol. That said I did learn from my mistakes and throw myself into the things I love from second year on and made some amazing friends!
tldr: go actively seek out things/societies/clubs you enjoy, don’t bother with drinking/clubbing if you don’t think you can fit in with that environment! Be true to yourself and I’m sure you will love it!