caligula rapidly turned into one of the most infamous and hated rulers ever as his brief reign of homicidal terror , extravagant living , and unrivaled debauchery led to his bloody death at the hands of his commander of the guard and senatorial conspirators , who once again hoped to restore the republic .