Ok, I have one place that was awesome when I first went down in 98', and I understand it's still kickin' This was mentioned the other night at Alana's and I remembered it because it made a pretty big impression on me.
It's a bar above a Thai restaurant on Esplanade. Now I went here about 4 nights in a 5 day stay and have been back once since and I never knew the name until I searched it out on the internet just now.
"Dragon's Den Social Aid & Pleasure Club"..
I'm not sure what the name is from, but it sure was a great place to hear great music, meet plenty of friendly locals and get yourself altered.
IIRC Monday is two for one sake night, and they serve it to you hot in 8oz plastic cups out of an aluminium coffee urn.
Straight class all the way.
If you dare venture onto the balcony (that is if it hasn't fallen off onto the sidewalk yet) you can cool off (relatively speaking) and talk to your new friends.
ETA: Anyone else been here? I know someone here must have been.