It would be fun to retire in NYC. Or at least have a place there to stay when I needed to go there to get an NYC fix.
The prices are crazy for what you pay for square footage you get. But, it is like that in all of NYC so it's somewhat normal.
For the same price you pay for a 900 sf condo in Brooklyn, you could get a big 4-bedroom house in certain areas of Rhode Island.