Answer:
No, it's a beautiful and vibrant borough.
And it has also gone through a lot of gentrification in the 20 years or so. After Manhattan, it seems to be everybody's favorite borough nowadays.
Nobody in Manhattan would ever take the subway to the Bronx, or Queens, or especially Staten Island, to hang out. It's usually the other way around: people from the other four boroughs come to Manhattan for the nightlife. But nowadays, many Manhattanites will cheerfully inconvenience themselves by taking the subway out to Brooklyn to party, instead of going to the bars and clubs in Manhattan.