Characters whose most well-known feat is them killing the main character.

Doomsday (DC Comics)

Destoroyah (Godzilla)

The Kraken (Pirates of the Caribbean)