I disagree with the parts about Trump: he does know what he is doing. Not because it's a well crafted plan of 4D chess, but because he's deeply anxious/insecure and "lie with grandiosity" is a learned survival mechanism to protect his feelings from reality.

It's like expecting a fish to stop swimming - it feels like it's suffocating, it's going to panic and do everything it can to get back into the water, get moving again. The fish isn't playing 4d chess, it's just flipping all over the place until it feels safe again, and then probably forget all of the chaos minutes later.

How much this is applicable to the other examples - Musk, Napoleon - unclear. But saying they do "stupid" things without looking at why they might do stupid things is reductionist/overly simple/can PROBABLY be answered with psychology in most cases.