I love the new streetlights! I was born in Seattle and have lived my entire life under the queasy orange-pink pallor of the high-pressure sodium streetlight. The new LED streetlights have a more pleasant color and better color rendering, a much more effective beam spread, and they cut way, way down on streetlight-related light pollution. Looking across Rainier Valley from my home, I used to see hundreds of the old streetlights dotting the east side of Beacon Hill. Since the installation of the new lights, I can barley make out a couple dozen. My point is this: there's no reason that light from streetlights that are miles away should be streaming into my windows at night. Now it doesn't, thanks to the new streetlights.
Yes, there's a glare issue, but there had been with the old lights just as much as with the new ones, we were just used to it. It's straight-up physics folks, if you want light, you gotta have a source. I think that given time City Light will find solutions to your individual glare problems (by installing glare shields, etc), just as they did with the old lights.
The new lights are here to stay, the city has spent years and millions of dollars making this improvement a reality. We'll all reap the benefits of better, safer illumination, greater efficiency, and lower maintenance costs.