I may be a little bias with my response, I live in Bay Ridge, and all together it would be a good choice. A fair amount of people who live in this area of Brooklyn have cars and commute to the city. And if you don't feel like driving, just hop on the subway, which only takes about 30 minutes to get into Manhattan. Plus you get more bang for your buck, its certainly cheaper than the "hipster" areas, such as Williamsburg. Two bedroom apartments go for around $1400, down here in Bay Ridge. For NYC its a great deal.
If you do choose Williamsburg or those areas, just don't go too far east. East Williamsburg, Bed-Stuy and East New York can get a tad gangy.