Is it worth staying outside Manhattan to save money?

Did staying in Brooklyn, Queens or Jersey City save enough to justify the commute to Manhattan? Which area offered the best balance of hotel price, transport and late-night return journeys?