My dog also goes with me as often as possible and I enjoy finding new dog friendly places to take her. But I think its obnoxious to bring pets places they are not allowed.
First because I believe its very important to respect the feelings of others and I've met a good number of people who are genuinely terrified of dogs or disgusted by the idea of them in a restaurant/grocery store etc. If a place says no dogs allowed, well, thats the rules and they should be followed.
And also because, it does cause issues for people with genuine service animals. Anyone remember the "emotional support pig" who caused that ruckus on an airplane? Business owners hands are basically tied when it comes to animals in their establishments. They can say no dogs, but the moment someone claims their dog is a service animal, they HAVE to let it stay. They CANNOT ask specific information about the persons disability or the dogs certification (indeed, service dogs can be legitimately home-trained). Its very tricky for them as the questions they can and cannot ask must be worded quite specifically. And, if, heaven forbid, they kick out a legitimate service animal, they can face a costly lawsuit. But enough incidents with unruly pets, and you can bet there will be consequences, generally for those with a legitimate need.
I should also point out, I have no issues with Emotional support animals. I have an emotional support animal myself. But they are not service dogs, they are NOT allowed in public spaces with a few exceptions (they are allowed on planes, and in no pet housing- with proper documentation), and they should be well behaved. I worry that people with legitimate service dogs and ESAs will suffer because of pet owners who insist on not following the rules/taking advantage of service animal regulations.