It really depends on the execution, but yeah, they can certainly spice things up a bit.
Though, for clarity's sake when the protagonist is the villain, the story's antagonist will typically find themselves as either another type of villain (IE: Hellsing: Ultimate) or as the Hero of the story...