No NYC subway lines drop to 1/hr late night. Some lines stop running entirely, and others switch to making local stops, but the scheduled late-night headway is 20 minutes between trains [1] on all lines that run at night. It's been that way the whole time I've lived here (a decade) at least, probably longer.
Obviously this can be affected by track maintenance, police activity, etc but that's not the norm.
Other rapid transit systems in the area are a bit worse, but still not 1/hr. PATH late-night headway is 35 minutes; Staten Island Railroad's is 30 minutes.
The commuter rail systems (LIRR, MetroNorth, NJ Transit) may indeed drop to 1/hr or worse per line, but that makes more sense for heavy rail.
[1] https://en.wikipedia.org/wiki/List_of_New_York_City_Subway_s...
When I lived in NYC, it was the basically the same. Most subways switch to 1/hr after midnight, most parts of the city are sleeping. Union Square wasn't interesting at 3am, neither was Madison Square Park or anywhere around Central Park. There's stuff in SoHo/Tribeca, but not that much. At least that was my experience.