It felt somehow really bad when one asteroid destroyed one of your towns, by the end the map was a melting pot of craters, and that is only ONE kind of Apocalypse... that is.. FIRE...
before that there was WATER apocalypse, raising seas, by it was not like huge Tsunamis covering the face of the planet but the Mt- Everest... it just flooded plain tiles and that's it...
The other kind of Apocalypses we know of are WINTER, or ICE, dark skies, no sun... and I still miss one???
I think the old Alien ships in SimCity beaming down laser beams were quite an attraction... these could be replaced by OTHER kinds of asteroids, like COMETS... with fire tails that would vapourize everything in their path, creating desert, nanodiamonds, glass shards, and maybe give birth to a NEW water source as many miths told us???
There's all kind of different creative approaches that could be added-subracted...