Only a fraction of a CPU is active during a given time period (eg if no floating point arithmetic is needed); and we don't use all the muscles in our body most of the time either. That's a bit different from what the pop-psy authors meant though.
Usually what these brain scans depict is, more or less, how "different" (brighter usually means larger statistical significance t-values) the oxygen-usage activity of some test state is from the same oxygen-usage activity during some rest state. Google fMRI (or look here: http://www.scholarpedia.org/article/fMRI).
Sometimes this means "less" activity than at rest state. Sometimes this means only very slightly (but consistently) more. Moreover, parts of the brain that vary considerably from trial to trial, but average out to a negligible difference from rest state, would also be easily ignored. This should give some sense of just how many assumptions and calculations have gone in to the pretty brain heat maps that the media are so fond of.
Lots of good and interesting stuff can be and has been figured out using fMRI. That said, figuring out how the brain works using fMRI is like trying to figure out how an economy works by observing CO2 emissions from space, at a resolution of, say, 10m.
That one can and does happen. There are recorded instances of seemingly heroic strength where, for example, parents have lifted a car to rescue a child who was trapped underneath.
The thing to note about this is that it essentially impossible to not seriously hurt yourself when you do this. You will tear the muscles. They are operating at their highest power before the wheels start flying off, and you'll tear a lot of fibers.
Edit: in this context, consider the muscle prostration of a person who has been tazed (which forces total contraction electrochemically).
t-nation.com reckons it's related to nerve signals rather than individual fibres tiring tho'.
Self-esteems is a dangerous one. Trying to somehow artificially increase someone's self esteem I think could be dangerous. It could create an emotional and cognitive dissonance, something like: "My parents and teachers tell me I am so awesome, but I know I cannot do things as well as my peers" or "I am supposed to feel awesome even though I scored in the bottom 30% percent on the test" from my own experience I have seen kids get disillusioned with their parents or teachers and basically stop trusting their opinions, or, even worse, the delusion gets maintained all through adulthood. They grow up arrogant, they continue to under-perform professionally or academically, yet they never consider their own lack of skills or smarts as the reason for the failure, somehow they blame it on others or on circumstances.