Uni is, as I and many people have said before, what you make of it. So what if the club scene in Cambridge is, basically, crud? I've found that I've had far more fun and enjoyment just sitting in people's rooms until the early hours chatting and drinking. Other than that, most of the social life during the day and early evening revolves around your staircase. If you've got a nice bunch of peopel (which is pretty much guarenteed!) then you will have a great time.
The point I'm trying to get at, is that the collegiate atmousphere means that there's allways going to be a safety net and people who you can turn to. No matter how late in teh night it is, chances are that there's someone up and about who you can talk to. If you're feeling down, then there will be a person about to have a cup of tea with and a moan about how much work you have to do...
Other than that, in terms of going out you get as much from going with a few friends as any. No-one cares if the club is a bit shoddy- if you're at Cindies at half one with a load of mates, with your hands in the air dancing along to "Summer of 69" or "Wonderwall" or whatever, then you will really enjoy yourself. Anyway, you're not going to go to more than two or three clubs in a night, anyway- and even that's rare- so who cares if there's only 4?