I've had this same experience, but a perspective from not necessarily working from coffee shops but places like airbnbs. Mostly it's awful and stressful like you mention. Many airbnbs don't have great internet or a comfortable desk to work at. I've had nothing but issues with Airbnb wifi even when the host has, literally, told me things like "we have solid fiber internet 1gbps" after confirming specifically and laying out my use case. My house has a legit 800kbps down over wifi, which speeds up development and increases reliability of connections significantly.

I really need a home base with reliable internet and a comfortable spot to work. I have never been able to find this at all on the road, and certainly not consistently.