If it works for people, then great. I drive in this area all the time, and for the vast majority of living situations in Brooklyn and Manhattan it would be a hassle that would discourage most people. The 110 outlet at the curb is the roll of the dice if you get the spot back. In many of these neighborhoods, if you get home after 7, you have to park blocks away. If the chargers don't multiply as fast as the cars do, especially the Model 3, there will be a lot of bad press about charging situation in those areas.
Brooklyn and Manhattan are different because there is much less street parking in Manhattan. When we get a good snow storm here cars on the street in Brooklyn can be buried for weeks and the spots get even fewer because of the piles of snow. If your outlet is buried you may not get to charge your car near there for months, leaving you to add a trip to a supercharger, which will likely be very busy, and then add the hassle of parking the car back on the street where you live.
I want these cars to work. I love mine. For suburbanites like myself it is perfect. I never have a range issue and my car is garaged at night with chargers at both ends, work and home. There are plenty of superchargers for trips along my routes and all is great. Telsa needs some serious infrastructure in NYC if they are going to push their cars for urban dwellers. The model 3, when it is plentiful, would be a great zip car.