It depends on the music and scene that interests you. Most SF nightclubs are event spaces that host independent promoters of recurring events, so the music and attendance can vary. You'll generally get best results if your friends will be there and you want to see the performing artist(s).