Don't forget Gary Condidit.
Most people don't hold murderers in high regard. Though Condit's public reaction was rather dismal, and doomed him in and of itself...