So much thanks for all of the responses, really settled my fears aha.
From what I've been told, and common sense, it's really what you make of it and the friends you make. Obviously it's not Bristol so the clubs aren't there but the motive still is, so there's flat socials, SU and occasionally the RH takeover buses that go to London and that. I also know friends who train to London twice a month and uber back after nights out.
But yeah, thanks for the responses and crazy amount of messages, safe to say I was wrong.