@olibong in my opinion, no one should be unhappy for four years of college. BUT keep in mind, a weekend or two visiting is not the same as living there, taking classes and socializing.
That being said, if you can afford the costs to attend NYU, apply to transfer.