I mean evil geniuses, supervillains, and bad guys. World-ending mega beings can still be a plot. And it could still work if there were other inhabitable planets pre-established in your universe.
A lot of amateurs try to slap on a "blow up the Earth" or "blow up the moon" plot, which is more cliche than trying to take over the world. Logically, this would be an absolutely terrible idea.
"Hahaha, with this laser I'll be able to blow up the moon!" And accomplish what, first of all? That's not ultimate evil, that's just terrorism. I mean, it's a display of power, because it would take a lot of energy to blow up something that big, but what would it accomplish? Any supervillain who isn't intentionally created to be a complete dumbass needs to have a plan. Robbing the museum of the largest, rarest diamond in the world? Easy. That's bound to be worth a very large fortune. And it would be a symbol of status and accomplishment to say you possess the most valuable diamond that exists. Robbing a bank. Petty, but easy: money. Blowing up bridges: it prevents people from leaving a place, allowing the villain to turn it into a dictatorship and rise to a form of power. But blowing up the moon? What good would that accomplish?
Even if you argue "that would show the world you have the greatest weapons, and force them to do your bidding" I'm sorry to say that the world isn't going to give a shit about you after you've blown up the moon and thrown the entire planet into a climate disaster of biblical proportion. First and foremost, the enormous chunks of moon are going to come raining down on the planet, wiping out city blocks, whole counties, and even countries if the pieces are big enough and fast enough to make it through the atmosphere in one single monstrous part. If you were planning on ruling those people, well, destroying them with raining meteors is fairly counterintuitive.
The falling moon shards is going to be the least of your worries, though, because without the moon, the tides are going all out of wack, killing more of the people you intended to intimidate and control, and causing massive amounts of destruction to the planet you were hoping to rule.
The dust and debris thrown up by the moon meteors could easily block out the sun, changing climates, killing plant and animal life, and wreaking havoc on economies. If a big enough part of the moon hit the Earth, you could even wipe out the entire thing, yourself included. It would superheat the world, causing all the seas to evaporate. But that's not even the worse that could happen. Even if it didn't destroy all life on Earth, it could easily alter the tilt or obit of the planet, permanently changing the climate of Earth.
Amid all that, the places that survive would fly into complete disarray. Markets would crash or even go up in a puff of smoke, economies would take a nose dive, as places and systems integral to the economic stability of many places on Earth were either destroyed completely by the severe changes to the planet, or wrecked bu them.
Wars would break out over resources, possibly nuclear war, riots and looting would flare up, all kinds of crime would spike, and it would take decades if not centuries to completely recover. Even if you, as a supervillain, were the richest man on Earth, you'd also be effected. If were weren't killed by flooding, or bits of falling moon, you'd still suffer the devaluing of your wealth. By the end of it, you'd be lucky to even be alive. You might be able to gain control over a small number of confused or frightened people, but you'd still need food, uncontaminated water, and the ability maintain hygiene so that you don't die before you can take over the world.
Out of all the "rule the world" plots, this one is the worst, and least efficient. And even if the goal is to cause chaos and throw the entire planet into turmoil, this is still a terrible way to do it, because it could very easily come back to bite you in the ass if you've not planned to the nth minute detail.
As for blowing up the Earth, well that one's pretty obvious. If you blow up the place you live, you die in it, too. But let's pretend you're like Doctor Robotnik. You've got a starship you can live on, you manage to avoid getting sucked into the blackhole left behind by the Earth, and you manged to not die in the blast or get hit by flying chunks of planet. Ok, you blew up the Earth, you've just made you and your crew the loneliest people in the galaxy, or if you don't have a crew and every other human was destroyed, you're now the loneliest person in the galaxy.
Regardless of the number of people who survived your plot, you've now thrown yourself into a very unstable situation. You're going to be aboard a ship hoping to find and reach an inhabitable planet. So many things could go wrong, in that time, that could kill you and your entire crew that the pros are just astronomically outweighed by the cons. To survive, a person needs clean food, clean water, and clean air. It would only take one guy on the ship suffering pandorum and wrecking the ship to compromise one of the essential needs of the ship's crew.
But what if you're alone and suffer pandorum? Or what if you don't? A lot of people think they'd be well off all on their own, but not a lot of those same people realize how much interaction they have with other people. Even if you mostly isolate yourself, you're still getting online, and you know there are still people you can interact with. Not a lot of people realize just how hard it can be on a person to be truly and genuinely alone. People shipwrecked on islands start to go insane and make up imaginary friends.
Recognize him? His name is Wilson.
After blowing up every other form of life in the galaxy, deep space would get real lonely. Even the most hardened villain has someone he/she interacts with to some degree. They might be fine for the first year or two. But what about 10? 20? If there are no aliens and no companions, that villain is going to be alone for the rest of his/her life.
Let's say they have a companion, even if it's a dog, and they've got the loneliness thing covered. A ship in space is no guarantee. You could get hit by space junk, or get hit by a solar flare, or fly through a magnetic storm, a lot can go wrong when the thing you're relying on for survival is isolated from ways in which it can be fixed.
And at the very end, even if the person who blew up the Earth manage to make it to a new, habitable planet, he still has to survive it. And with no one around but him and his crew/companion, life on this new planet is going to be a lot more meaningless. There would be nothing to strive for, no one to appreciate their greatness. If they had a crew, they could establish a new civilization, but that's not exactly easy, especially not on an alien planet.
This post got a little deeper into detail than I intended for it to, but no matter what way you slice it, blowing up the moon or Earth just aren't worth it. They're super inefficient. If you want to show your power as a supervillain and rule the world, it's more efficient to not wreck the world you wish to rule. If you want to watch the world burn, do it in a way that won't potentially lead to you dying a slow and painful death. If you want to start a new civilization, blowing up the entire Earth doesn't need to be a thing that you do to accomplish it. You can just leave the Earth.
If you want to be evil about it, and leave with a thunderous "muahaha", you could rob Fort Knox or something. That way if you screw up somewhere along the way, there's still a working planet with a working civilization to return to and you don't have to die pitiful and alone in space.
So in a logical sense, someone like Lex Luthor blowing up the Earth or the moon just doesn't make sense as a plot. Maybe he's a bad example because he comes from a universe were there are dozens of other planets to live on, and parallel universes at the ready. Alright, Syndrome, then. It doesn't make much sense for someone like Syndrome to do something like that.
To reiterate, though, the plot is still viable if the universe supports it, or if the villain is comically stupid like Glowface, Kronk, or Dark Lord Chuckles the Silly Piggy, and doesn't realize there would be consequences to blowing up either or both of the two celestial bodies vitally important to our way of life.
Upon reflection, the story of a supervillain and superhero, stranded in space after the villain blew up the Earth, and both of them struggling to survive pandorum and the bleakness of space might actually be a brilliant movie plot. Care would have to be taken to keep it from being too similar the movie, Pandorum, and every other 'stranded in space' story, but at least it would be different from every Superhero movie that's been released and will be released from now til 2020.