I hate clubs too, the whole point of going to a club is to have fun, but like you said people don't have fun there. Its like a HS dance with alcohol, guys stand with the group they came with and the women stand with the group they came with. Clubs weren't meant for people to get drunk, neither are bars.
It took me about a year and a half after I turned 21 to learn the bar etiquette: you don't get drunk in a bar. When you're underage you go to parties, where everyone is wasted, doing dumb shit and being young. At a bar, you think that since these people can legally drink, have tv's everywhere, the jukebox going, pool, darts, videogames and all this stuff you wish you had at a party that they would be going wild. Nah, its usually just a bunch of old people feeding their need to drink and they're too afraid of becoming "alcoholics" so they do it around other people.
I used to get drunk at bars, I mean fall down, make out with your wife, puke on the pool table drunk. Even before I did that, the people in the bar (guys/bartenders) hated me because I was young, new and got attention from women. You'd be surprised how often the regulars at the bar covet women that they see often and seeing a new guy come along and "butt in",...it really pisses them off.
I'm going on a tangent, but for the most part: don't go to a bar alone (no matter what), don't let someone you don't know into your group of friends while you're at a bar and don't get drunk.