I enjoy Trigger and Cafe when I wanna just let loose and dance, they both have hot dancers and is a little more "nightclub" than the other places. Badlands is cheap and has good gay music but it can get a little too packed (i.e. sweaty). Q Bar is good too, a little tamer than Badlands. My friends like Toad Hall for pre-dancing drinking. Hope that helps!
I cant imagine who goes out midweek, but you're best bet is to try the bars in the castro maybe? There are about a dozen within walking distance of each other, 18th and Castro being your ground zero. You can take the MUNI to the castro station or a cab from downtown would be about 10-12$.
I have come here a couple times now for work, but never know what to do. I stay in the wharf area since my work is in North Beach (?), and always work alone (no co-workers), so ... well... catching up on Walking Dead on my laptop. :-)