The scene of a party really dictates how it's going to go, the one that you ended up at? Well, that's the kind of party that I probably wouldn't like very much either. But the "hipster-crowd-counter-culture-ish" parties that I frequent are mostly great and not at all like what you experienced. It sounds like that's the sort of "rager"/house turned into a club that is what you see in movies or on tv when people try to depict college parties. Despite you not enjoying it, I would say it might be beneficial to look at it as a moment of you stepping outside of your comfort zone. There's nothing wrong with that, and I don't think one bad experience should permanently shut you off from trying it again, because as I said mileage may vary when it comes to parties or stuff like that.
Exactly, "mainstream" parties are crap because "mainstream" people at this point in time aren't really "interesting." It's more like a gathering of people trying to replicate an experience planted via media. I live in NYC and you could not pay me to goto a normal club or bar. The experience is hollow and not really entertaining. On the other hand, house parties with friends, fetes, burner events, and the DIY/small venues scene is pretty much always sweet. Haven't had a bad night out since I gave up on assimilating into the mainstream. Also, alcohol sucks. Seriously. Drunk partying is at the bottom of the totem pole of party experiences. Saying otherwise is a sign that you've never actually partied. And if we're going to talk about drugs. Cannabis, MDMA, & low/micro doses of psychedelics facilitate a party experience far better than alcohol could ever hope to