The City that Never Sleeps is definitely a nickname tied to New York, specifically. I've never heard the nickname used to refer to other cities. Maybe some people have started co-opting it for other places, but if you Google the phrase, a bunch of NYC stuff shows up.