I'm aware of the zoning history, I'm a former resident as well. Good counterpoints, all. I think "the perfect neighborhood for the city to grow into" is an optimistic and accurate description.

>It's the densest concentration of artists in the outer boroughs

Surely this crown belongs to Bushwick, but LIC is not entirely devoid of arts and culture (Flux Factory being an example of a repurposed warehouse you describe).