Basic Trope: A large object from space is being used as a weapon against people on Earth or other planets.
Played Straight: Earth or an inhabited world now has colonies on the moon(s) and the La Grange Points. The Big Bad de-stabilizes the moon(s) and the artificially made La Grange Point colonies and sends them hurling towards an inhabited world to kill lots of innocent people.
But another villain comes along and has the same idea.
The Hero only delayed it.
Deconstructed: This is usually being done as a show of power, but if most life would be destroyed by large objects (natural or artificial) hurling towards a world, who will be left for the Big Bad to rule over?
Zig Zagged: The Big Bad screws with the gravity on the La Grange Points, causing their colonies to come hurling towards the planet, but then The Hero helps them get back where they belong or sends them floating away. This happens several times.