I'd love an end to the Supervillains a la James Bond. I mean, after Khan and Nero and Shinzon and Chang and the Borg Queen, etc. I'm half-expected the Enterprise to go up against Loki or the Red Skull next time...
The difference with Chang, Ru'afo and the Borg Queen: the focus of the story in these films was not about them. You can remove these characters and the main story is still intact.
Khan, Nero, Shinzon and Soran are these Bond type villains because the story focuses solely on them. If you remove them, the story falls apart.
It's okay to have a villainous character in your story, but it gets tiresome if he is the focus of it.