So, when I tried to check in here last night, I found that the other Memo's Cafe on Yelp is located on the wrong place on the map and was unable to. Therefore I am being forced to relocate my review to make it geographically accurate! I am going to update it as well:
Memo's has quickly become my only hookah spot. Between the excellent Shisha, the attentive coal-changing, and the varying atmospheres depending on the evening, I would highly recommend Memo to take care of any of your hookah needs.
The best night that I've been to so far is definitely Tuesday, Kareoke night. There was literally an entire dance floor getting down, and to see such a sight without the addition of alcohol is definitely nuts! The Kareaoke was actually really good, although there's no way I'd have the guts to get up there myself without a few Cue Club long islands.
I generally go for Memo's blend for Shisha, but there is a wide selection and they use Al Fakher, which is my favorite brand as well.
There is a drink minimum, but water counts and is only two bucks.
Overall, definitely the best place I've been at - great atmosphere, and it's been getting packed recently which makes you feel like you're out, even without a hangover in the morning!