What has always puzzled me about statements about self-esteem is that it's never seemed, in my case, to be remotely consistent over time.

Same here... I seem to believe that I'm both a genius and an idiot, that I'm both good at Magic and bad at Magic, and many other such apparent contradictions.