haha different neighborhoods of NYC are like totally different countries. that's why NYC rules.
i recommend checking out Long Island City. I think places there are still relatively cheap (at least more so than Williamsburg and Greenpoint) and it's got good access to Manhattan.
I live in and love Carroll Gardens, but it is a tad expensive. You can find some affordable places around 3rd Ave I think though. Check out Gowanus.