Having been all over the world, and lived in couple big cities, each type of city offers it's own appeal.
Manhattan, by far, is not exactly paradise. But it's not a bad place either. You like the small town atmosphere, great, but unlike other small towns, having a major university within the city limits gives it some pizazz.
Having grown up in the Little Apple, and having returned about once a year, I have come to realize how different the world really is. I could not live in Manhattan again. Kansas City, maybe, but never in a small town. I lived in Berlin Germany when I left Manhattan, and talk about a BIG TOWN, it was about 110 miles across at it's most widest points. I lived in Manhattan NY, for about 3 months on a job there and while it's got the same bustle as Berlin, and as many people, it really wasn't much different, other than I could understand the obnoxious people. Living in the Phoenix Area, I have grown accustomed to the wider expanse that Berlin carries, except out here, it's like pretty new. Who'd a thought that having a block wall fence around all the properties was a cool thing?
Big Cities offer more opportunities for me for what I do, and so I have shedded the small town community lifestyle. Manhappiness will always be a quaint little town because there are enough people of influence there that want to keep it that way. That's not to say it couldn't be better, just that one of the business reasons Manhattan is such a bad place is the political nature of the Manhattan Chamber of Commerce. The old "big fish in the little pond" is what makes it unattractive for any real growth and opportunity. My Dad owns a furniture store there, and he still has lots of trouble trying to make his business go. Success requires a lot of external assistance, unless you can get a business that everyone will want to be part of.
For a recruit, it's the best place if you're serious about getting a good education. For a family, it has great appeal for a good and decent community, if you can find a job that will support you. For people like me that seek more out of life, then it's not the place to be.