In Aberdeen there's:
"The Noose and Monkey" which I have heard various things about. Ranging from it being a transvestite bar, to being "very artistic and non-judgemental".
"The Market Arms" - I didn't know a market had arms...
"db" formerly "Oh Henry's". Infamous gay club. Infamous because there are only 2 gay clubs in Aberdeen, so it's existence makes it infamous. My uncle, who is a bit of a homo/xeno/everything-o-phobe used to be a bouncer there.... which confused me.
"The Monkey House". Though if you've seen the neds in Aberdeen it's actually quite an appropriate name.
"The Tilted Wig". Which is a nice, quiet place to have a pint.
"The Tunnels" which is not the other gay club in Aberdeen (That's "Foundation"), but built in old air raid shelters under the main street. And across from Foundation. Which is also built into air raid shelters.