Move to Staten Island, that's where it's at, all the action you can get and then some.

really though, too many places to list but pretty much any neighborhood close the the river is usually pretty cool. I live in Clinton Hill/Fort Greene and it's great, just have to avoid the Pratt kids sometimes, but if you pick right you hardly ever see them.