Generally speaking, no, it is not worth living in NYC unless you have family or a network of friends already there. You can have a bountiful social life with good transportation in many smaller-than-NYC cities in the U.S.
Like where else even has close to nyc levels of being able to live without a car ?
Notice I said "good transportation" and not "close to nyc levels". If you want close-to-nyc levels, check out Philly, Chicago, DC, Boston, maybe Seattle or Portland. But you can live without a car in many more cities and have a fulfilling life, it just depends on what your needs are (obviously).