One type is the mega club. These are see-and-be-seen places. Ibiza. Vegas. Miami. The DJs are very famous, but often because they have a few EDM "hits"--not because of their selection or mixing skills. These places have tables, bottle service, and beautiful people. The DJs here often do nothing: they may have a USB drive that they press "play" on and then pretend to mix.
Then there's another class of club: the "indie" electronic music club. These places have djs whose skill is more about selection, mixing, and crowd/vibe management. The djs here often have respected production careers but often not.
What you do at these clubs is simply dance. Usually by yourself, listening to music. The best of these clubs will not blow out your hearing because the sound system is exquisitely tuned.
As an introvert, the second class of club sounds like it would be perfect for you!
As an aside, if you've never experienced a truly world-class DJ (of the second type, not the first), it's an incredible experience. Even if you find electronic music "boring", these people are absolute masters at taking you on an emotional journey.
The best way to experience this is at one of the top festivals. The second best way is at a club. The third best way is at home, with great headphones, and soundcloud/youtube dj sets. NOT spotify.