From the TVTropes Cool Loser page...

[froodle]

The Eerie, Indiana books attempt to justify this: the charming but unpopular town bum, liked only by the main characters, used to be the mayor before he irritated a witch.