When I visited in April the clubs all had massive lines that reminded me of vegas places. The clientele weren't that high end, but still not tourists.
For
@OrlandoGuy, combining the comments from TS and this, I think you're looking for something that ISN'T available outside of a college town. I'd love to meet up with you over a beer on this, but my college experience was many small house parties over blocks and blocks of our residential community. Even my fraternity parties were small affairs.
During HHN I did a post-game at one of the bars and frankly didn't care for it. It's not my thing, and that's ok.