greenpoint all the way.
it's a real neighborhood with character, plenty of shopping and culture and stuff, close to everything, interesting scenery, and the lack of useful transportation (read: no subways that go to manhattan) keep the rents and the crazy development somewhat sedated (for now, at least).