I never understood the coffee shop thing. I hate working at coffee shops, people nosing around at what you're doing, never enough desk space, that feeling of guilt once you stay there too long, etc.
For me: I work solo from home, so sometimes I go to the coffee shop for a change of atmosphere & to be around people for a while. I find the white noise of the cafe helps me focus, as does having people around me. It's nice having someone serve you instead of having to make your own coffee/food, and sometimes the food is nicer than what I'd make myself at home. But I try not to stay too long & only go at times when the cafe is half empty.