I think Street View is awesome. I enjoy being able to see what the location actually looks like before I go there, or just "cruise" through places for curiosity's sake.
My objection to Street View, on the other hand, is simply this: It's an easily accessible archive of private property. Sure, it's taken from a public place, and any number of people could have taken that picture. They may have even uploaded it to their blog, thus giving it exposure on the internet. But google? I don't know...
I guess I don't like the prospect of just anyone being able to type in my address, and get a picture of my property, even from across the world. I would defend my neighbors right to take pictures of my property, or even that of a tourist... But Google is a corporation that,in this case, is selling my details for a profit.
For whatever reason, it just doesn't sit well with me. I think I'd be less opposed to it if the would go down main city streets, and not veer off into neighborhoods.
As for the Greeks- I think they take it a bit too far. I completely agree that if it's a public place, there should be no expectation of privacy, and people should be able to take pictures, video, audio, et al. to their hearts content.