From the looks of things, we might be able to edit units in Python if it's that integrated. That way, you can give nukes varying radii and effects.
i.e., imagine a "nuke" that, when it strikes, gives an X radius of damage (and even turn the terrain type - i.e., flat terrain to coast), plus turns all terrain around the radius into hills. If it's already a hill, to a mountain. If it's a mountain, then a snow capped mountain, or volcano. All cities, units, improvements within X tiles of the circle could be destroyed. You could also rename the nuke to "meteor". I think that's the power of the scripting engine -- to do just about anything we want with the game. I wonder if this could go as far as "seeing an animation" and sound effects. (i.e., a 1 second delay before the next set of tiles changes).