I used to go in there week in, week out a few years ago.
Used to go Friday night & Saturday night. I grew out of it in the end.
This is the thing you must remember, it's a VERY young crowd in there. It is notorious for letting in people who are evidently under 18. I'm 28 now and I don't think I'd fancy going back there, it would need to be a very special occasion. Also, the music will not be for everyone (rock, metal, goth) etc.
Having said all that, I have had some absolutely cracking nights there in the past, as well as some very forgetful nights. It is a place that you probably do need to go to at some point, it is legendary in Hull. Though, like I say, not been for about 4 years so couldn't say what it's like now.
The main reason most people go - the booze is ridiculously cheap, and they sell an array of strange cocktails that are lethal. When I went, I'm sure a shot of tequila was 50p. Something silly like that anyway.
Have a look, I'd say. And if it's ****, just get yourself up Witham instead (the women there are scarier than the goths in Spiders).