In "Bruce Almighty" Jim Carrey uses his God powers to move the moon closer to create a more romantic view for his date. If my memory serves correct, the next day we hear briefly on the news about terrible freak flooding over the world.

I remember that movie and that scene. :)