I love taking our dogs to pubs and cafes whilst we're out and about and we socialised and trained them from very young so they're generally really good. As others have said, once they've had a look around and maybe checked there are no stray chips under the table to eat they just lie down and sleep.
I get that some people don't want to share their space with dogs so it's good that there's still places with no dogs allowed. I've got friends who are very allergic and one who is phobic so they really need dog-free places.
I really notice if there's bowls of water, dog treats on the counter and if the staff make a fuss of the dogs because then you know they're really welcome and we'll make a point of going back.
I love dogs and kids but if I'm really honest, I'd choose a pub/cafe full of dogs over children every single day. I've had plenty of meals out spoiled by badly behaved children but never a dog and that's generally because dog owners are usually very conscious of making sure their dog doesn't disturb other people. Some parents, not so much.
The only shops I've noticed being dog friendly are places like garden centres and pet shops, I've never seen a non-working dog in a clothes shop. Does this happen?
I wouldn't take my dogs shopping, they'd be bored shitless!