There's a hookah bar by my apartment that has just the vibe I crave from a coffee shop. It takes ~1 hour to smoke a whole hookah, and you can go with some friends, socialize, work quietly, and they don't blast music. I believe it's like that because it's next to a university and usually full of students. Other ones around me aren't like that.
Unfortunately, it comes with some dangers...nicotine.