The following are cities that were either partially razed or were completely razed but i'm too lazy to get the full info on. However, enough damage was done such that the place was inhabitable and more than half the population was either killed or displaced (basically what it's like when a city is razed in civ)
Warsaw, Poland
Nanking, China
Hue, Vietnam
Kigali, Rwanda
Soweto, South Africa
Phnom Penh, Cambodia
Dili, East Timor
The nuclear example was in response to someone saying "even the most powerful nuke wouldn't obliterate nyc" so it's kind of a moot point.
As far as RL reasons for razing a city, there are two main reasons:
Ideologically driven: Normally some form of racial- religious- or political-cleansing. This is most notable in Nanking, Kigali, Phnom Penh and Huambo
Scorched Earth: Often, if forces make a rapid and unexpected move into enemy territory and seize a city, it is not feasible to keep the city, and razing is the best option militarily. Alternatively, if you have no desire to police that city or are on the retreat, then razing is also a good option. Examples include Warsaw, Soweto, Qalaat Dizha, Grozny, Hue