Brooklyn is enjoying a renaissance with many enjoying the resurgence of up and coming restaurants, theatres, etc. In addition Brooklyn is enjoying rising property value as more and more residents are fleeing Manhattan to take advantage of community/neighborhood living and scoring brownstones with backyards. The schools are improving for your children and the Brooklyn Children's Museum has also been renovated.
Cons include a longer commute into the city if you live in Manhattan, a bit of crowding in some areas, and some neighborhoods have not been completely gentrified although they are well on their way. Brooklyn is definitely worth exploration and consideration.