I'm in a similar boat - I don't like drinking, clubs, anti-drugs and pretty shy. It's horribly cliche sounding I know, but clubs are honestly your best bet and they don't necessarily have to be in University. An example of this are the classes/clubs held at Paperchase for arty and crafty people. There's also photography clubs, sports clubs, even stuff for film fanatics depending on where you live. Theatre, music and even make up are options so put your hobbies and interests out there!
My partner's met a lot of his good friends at the gym, local pool and through living at student accommodation. I met some of my greatest friends online. It's all relative but yes! It's overrated and hyped up to be something it's not, especially to introverts.