Speaking here as someone who grew up with a serve phobia of dogs. Had it from as young as I can remember until the age of 19ish, due to being attacked by a dog when I was little. Luckily I worked super hard to overcome the phobia because it really did control my life.
I was terrified of all dogs. Didn't matter if they were cute/small/big/quiet/old etc. Being too near a dog would cause me to have a panic attack. I'd be in tears, couldn't breathe, and it was just the worst feeling ever, I would be completely terrified, even if it was a chiwawa.
Having a phobia of dogs is really tough, because they're everywhere! There were certain places I'd always avoid, like parks. And there were also places I'd feel safe, like a supermarket or a cafe. For me, there was nothing worse than finding a dog somewhere I thought was safe, as it would catch me off guard and I'd be even more panicked and stressed. Guide dogs are slightly different since there's usually only one of them at a time. So, if there's one guide dog in a cafe, I can sit as far away from it as possible, although I'd still be nervous. But a cafe with multiple dogs inside would be awful for me, even if they're under the table, it would be my idea of hell.
I don't mind dog-friendly cafes, so long as there's a clear sign somewhere indicating this cafe is dog-friendly. That way, dog owners know, and people like myself who were really phobic, or maybe someone who has an allergy, knows to avoid it. I'm not a fan if there's no sign, as I think it's important to remember that some people are terrified of dogs and others have serious allergies.