And Abba. Lots of Abba. You have to be really drunk. If you're wasted already and go there to get more wasted, it is possible to have a good night. But that's only because you're wasted. Not because of the quality of music, staff, or dance floor.
Romeosbitch, I agree on the gay scene, though I'm not gay myself. That said, the alternative music scene is quite small too - basically being the cavern and sometimes TP. The West Country is quite small on nightlife, if you want to out out of the usual cheesy studenty thing.
But you can still have a good time if you do some searching and get lucky. Oh, good point on The Phoenix. Not many people look there, but they get some fantastic acts - like The Guillemots and Turin Breaks.
Good sign to stick to your limits, though, is that in my final year a guy tried to take a shortcut back to campus through The Phoenix after it had closed, collapsed, and I think he drowned in his own vomit in the end. Dead at 18. Happens once in a while when masses of people live the lifestyle. Sad, but common. Could easily have happened to anybody.