I think people take clubbing too seriously sometimes, they will say this club is great, that club is rubbish, in the end they are all basically the same, places where you go to listen to music and dance. If you don't take it too seriously then it's not hard to have fun, even if you aren't completely smashed.
When I was at uni in Leeds, I used to go to the Cockpit, Wire, the Faversham quite regularly, they were all indie rock places, sometimes I went to the Academy which was more mainstream, or to 90s nights at subculture and whatever, I had loads of fun there even though I didn't really associate myself as a clubbing type of person. Sometimes we would go over to Sheffield and go to the club nights at Leadmill which were similar to Cockpit, or go to 5th Avenue in Manchester.
I would prefer to have a night out somewhere where you can sit and chat to people first, as thats socialising, clubs aren't really social in that way, but I don't have anything against clubs.
The biggest negative I would say about clubs is that a clubbing night is not always great in terms of value for money. The times when I came back annoyed after a club night out would be if I hadn't especially enjoyed myself and had dropped £40. I remember one time clearly when I'd not long since split up with my girlfriend of the time and I was feeling sorry for myself and everyone at uni encouraged me to go out saying I should get smashed and have fun....I just carried on feeling rubbish in the club, watching all the couples there, and then had problems getting home and had an expensive taxi and when I got to bed I was like great...I feel just as rubbish as I did a few hours ago but have spent £60 that I may as well have spent on something else to make myself feel better!