Gaius’s (Caligula) short reign was marked by episodes of abuse of power even by Roman Emperor standards. The debauchery and disrespect earned him many enemies among senators and even among his own security forces.
Caligula’s short reign ended abruptly when his home security team killed him, his wife, and child in their home. I doubt many were sad to see him go; though anyone remotely responsible for his murder was put to death by example. Obviously, you can’t have murderous coups go unpunished.
All that said, he died very young, only 28. Clearly, he was not one of the great governors of the empire; he was very human in many ways. Growing up among his most illustrious family, only to have his father and brothers effectively murdered by the emperor when he was a child. His mother then given a death sentence via exile and his sisters very much restrained. Caligula, at a young age was exposed to some very poignant trauma.
Successfully navigating himself to the sole emperor of Rome, given his background, it little wonder that he didn’t turn out to be a righteous ruler.
Agrippa, d. 12 BCE. Æ As (11.51 gm), struck by Caligula. Head wearing rostral crown / Neptune standing holding cloak, dolphin and trident. RIC.58. VF+, brown patina. ex Superior Auction 6/1998 Lot 6949.