This is what I don't understand, the thrill is in seeing Superman use these enormous powers.
I don't remember watching Superman cartoons as a kid and thinking, "Hey this guy is too strong! This is terrible!"
I personally love an all powerful Superman, it makes him that more appealing when he humbles himself and try's to aid humanity through negotiations as opposed to taking over and forcing everyone to do as he wills, even though he has the power to do so. Not to mention behind in awe when he performs great feats of wonder.