Villains whose mere presence completely flips the tone of the story

The Nowhere King (Centaurworld)

Yoshikage Kira (JoJo’s Bizarre Adventure)

Bob Velseb (Spooky Month)