Your ideal coffee shop does not sound like a very profitable enterprise as opposed to catering to people ordering takeout and large groups who drink alcohol.
The few places I have found which more or less matched my points seemed to be rather profitable and I know have been around for a while. I've tried co-working spaces and didn't particularly like them. I know it's really subjective but most of them felt pretty sterile (like so many open-space offices). I find I'm more productive in a (good) coffee shop, but that's of course pure personal preference.
Have you considered co-working spaces?