It's interesting: I once wanted to move to NYC. My friend and I planned a move there - I was ready to go if I found a job. A job I did not find so I was not comfortable moving at that time. The more he tells me about the city, the more I'm glad I never moved.
Nice to visit, though.
I know people who have moved there and absolutely love it. But I also know some who've quickly come to despise NY. A lot of it depends on personality, I think.