How is Red Hook (Brooklyn NYC) these days?

The last time I lived in NY and travelled to Brooklyn, Red Hook had just come off of the very damaging article by LIFE, citing it as “The Crack Capital of America.” Not to mention one of the worst neighborhoods.

Now that I’m putting together a plan to relocate, this time to the city, I see that quite a bit of revitilization has occurred, and the images on GoogleMaps suggest that Red Hook is as attractive and pleasing as anything in Midtown.

I was wondering if anyone could give me the rundown?