I would say the benefits of getting your work done vs having complete and entire silence are not so easy to summarize. A lot of people in this thread seem to assume that an open space office is super noisy full of people talking where in my (very limited, I admit) experience there's hardly any noise other than the sound of people hammering on keyboards (and the AC). There are occasional conversations but those last a few seconds because, as I already said, if they were longer, people would move out of the way.
Maybe it depends on the company, people and office.
I hate the noise level here. I haven't yet worked up the courage to expense a good pair of noise canceling headphones, but it may come to that.
Polite requests to take it away are met with "Oh, she's usually not like this, I don't know what's wrong, I'm sure she'll be quiet now..." And nobody wants to be "that guy" by telling the owners to take their dog and GTFO. So the dogs end up staying.