People like magic narratives because magic acts as a force multiplier for a single person. The force multiplier in real life is the ability to organize a bunch of other people to do stuff for you. The real Merlin is Steve Jobs or Obama. Just like magic, the ability to do this is generally an inborn talent (theoretically it could be learned, but you can't do anything to change whether it's the kind of thing you like to do, just like you can't do anything to make yourself like golf enough to make yourself practice as much as Tiger Woods).
There are weaknesses to this comparison, of course. In real life when you are using social engineering to further your goals, you become beholden to the network of interests that support you (e.g. politicians, customers). Also, in real life the ability to gain positions of influence is not distributed in any egalitarian manner.
One of the reasons magic is appealing to programmer types, is because they tend to be weaker in these areas, and they wish that they could have access to the same sort of power, but based on the things they are good at (studying tomes, complex incantations) rather than the things they aren't good at (networking, salesmanship). If magic were real, I would definitely be dedicating a lot of time to mastering that, but even knowing the power of politics I am not particularly interested in becoming a politician.