It comes from the show Sailor moon.
It refers to a villain in a series that has unlimited resources, vast armies at their command, godlike powers, and could steamroll over the entire planet in a matter of seconds yet ends up failing week after week to a relatively small collection of determined heroes.

Ex. The borg are a sailor moon villain, as are, I imagine, the villlains from Sailor moon.