Not having much time, energy, or desire for much nightlife at this stage in my life, I can't render much in the way of personal experience as a patron, but I can offer a bit of information regarding various venues around this side of the lake. I'll start in the Weirs area, and work my way out toward downtown.
You should note that many of these nightclubs are seasonal, as the year-round population can't support a large number of clubs. Another thing to take into consideration is that none of the clubs here will afford you that "urban nightclub" experience - again because the population cannot support such an enterprise.
Paradise Beach Club - Open May through October.
Beach themed decor, offers live entertainment weekends with a variety of bands and a focus on dance music. (On a side note, their Prime Rib dinner is SUPERB!!!)
Weirs Beach Smokehouse - Open May through October. Offers live entertainment with a focus on rock music.
Club OG's - Open year-round. Features "hot dance music" with a DJ and lots of electronic light show equipment.
King's Grant - Open year-round. Features Exotic Dancers - not sure what else.
Patrick's Pub - Open year-round. Offers a variety of entertainment from Comedy to live music.
Jeremiah's - Open year-round. Not sure if entertainment is live or DJ. Offer's Karaoke on certain nights as well.
Funky Monkey - Open year-round. Features 12 pool tables and DJ dance music.
Club Atlantis - Open year-round. Offers DJ dance music.
I'm not sure if I got them all, but perhaps others will be able to complete the list, and offer more information about those I've remembered to list.