Hannibal Lecter, BBC Sherlock, and other more "Pristine" examples of sociopaths are far from normal, and usually just the writer's excuse to write a character that's disconnected from other people and can do whatever in order to get what they want. Most people with APD act a lot more like, well, antisocial people, and are very grating in social contexts most of the time because they don't think like other people. Either way, if you're going to find an APD person who acts like a fictional character, you're a damned lot more likely to find someone who acts like the balding guy from GTA V and has trouble functioning in most parts of life that don't involve movie moments, because it's a disorder, not a positive personality trait.
As far as "Charming" and "Manipulative" goes, you do realize that, when they do it, they don't usually maintain their charm very well, right? Look at Ted Bundy. He was good at getting girls to ride in a car with him, but he generally couldn't keep up the facade, and then he killed them. The serial killer who went on the Dating Game and won was able to convince a girl to go out with him in that social atmosphere, without even showing his face, but they split after one date because he was he came off as incredibly creepy in a one-on-one social context. Even people who manipulate others for years were usually relying on one bit in particular (Continual, repettitive encouragement, plain bullying, money, persistence, etc.) and weren't (or couldn't) get it to serve to any particular end, rather they did it compulsively because they could, wasting everyone's time, generally hurting other people for no apparent reason, and wounding their own reputations and social lives irreparably whenever they were caught.
It's called a disorder for a reason: People with APD generally don't function very well, certainly not as well as most people without it.