So ya wanna live in Brooklyn, eh?
Brooklyn Heights is nice, but the rents up there are high, similar to Manhattan rents. Go down south to Bay Ridge or Bensonhurst. Rents are around the low-mid 1000's for a 2 bedroom i think. Park Slope is kind of nice too. Parts of Williamsburg can be nice as well.
The best part of Williamsburg: Peter Luger's Steakhouse. If you ever have a sh!tload of money to kill, Peter Luger's is the place to go. I'm going there this Saturday, their steak sauce is the bomb diggity shizznit.
Marine Park is a nice area too, but it's very far from the city, if that matters to you.
THere's more to tell about Brooklyn, but it escapes me now...