There are 2 RCI resorts in NYC where you can use points for nightly stays. They are the Hilton Club and the Manhattan Club. There is also the Lowes Regency through the Concierge Collection.
We tried to get a few nights on points for early Dec 2010 and there was never any availability. We instead found a really nice hotel in the theater district for a really good cash rate.