The "Big four" Desire, Foxy, Cadillac Lounge and Club Fantasies can all be good, great or terrible on any given day or night.  The best thing about Providence is that all of these clubs are close together. If one is bad you can just leave and go to another.

It's a matter of taste but personally I avoid Cheaters, the Satin Doll and The Sportsman's Inn.  The former is just plain raunchy but if you want extras it's pretty much guaranteed since most of the "dancers" there are streetwalkers with their pimps sitting right at the bar keeping an eye on them.  The other two clubs just don't have very many attractive women and are downtown so parking is difficult.