Absolutely. Ill clarify here and state that I think what the US government was doing was wrong, and that by uncovering the illegal (in my mind, though there is some debate about this point) activities of our spy agencies the world is better off. Of course, leaking the information could not have happened if the original programs had never existed, but the leaks were the proximate cause for the damage to the U.S. geopolitically.
However, that doesn't negate the fact that by having their dirty laundry aired the U.S. has gotten a tarnished reputation. Its given ammunition to anti-US groups, lent legitimacy to other state actors acting poorly when it comes to cyber-intelligence/warfare, and damaged the economic interests of U.S. tech companies trying to have a presence internationally. I will leave it up to you to pass your own judgement as to whether this damage to the U.S. was appropriate/justified/legitimate/deserved, but I think we can agree that it has happened.
Now, to expand on my comment that there are elements of carelessness and narcissism. I think - and this is just my opinion - that Snowden has demonstrated an enjoyment of the limelight, and has started to model himself as a digital champion. I don't say this to condemn him, merely to point out that he is a human who has an ego, and isnt so selfless angel. Second, the carelessness that I refer to is things I have heard regarding failures in redacting information[1]. This doesn't necessarily mean that such failures aren't a cost that is negated by the public gain of knowing about these surveillance programs, but it is still a cost that must be recognized.
[1]https://www.techdirt.com/articles/20140128/08542126021/new-y...