James Bond. Even though I think your post is fantastic, and I've read it several times, I disagree with you on one thing.
You say that being a mystery, playing hard to get, etc. is all about insecurity. I call these things being a challenge. And, yes, you can overdo it, and have a girl dump you because she thinks you're playing games.
However, in my past few relationships, if I understood the concept of challenge, the relationships would have lasted longer. Instead I got dumped. I was seen as "too nice, too sensitive, desperate." Not because girls didn't know my intentions. They knew I wanted to f**k them. I came on very strong when I approached them, and went out with them. That's the problem. I came on too strong. That scared them off. Guys who do this are seen as emotional sluts. Guys who are ready to get married or fall in love right away. Girls see this "love" as insincere, and it scares them off.
Yes, girls want sex as much as we do. But, no matter how you look at it, they view relationships differently. You may have heard that men use romance and affection to get sex, while women use sex to get romance and affection. I think that illustrates my point in one way.
Challenge isn't about insecurity, or manipulating or seducing women. It's a way to keep nice guys from being "too nice". It's a way of giving guys some self-control, and control in a relationship. It keeps guys from calling everyday, spilling their guts out, and coming across in a way that will make them seem weak or desperate. Whether you guys want to admit it or not, 90% of the time, she controls the relationship. For most of us, 90% of the time, she dumps you. Most guys have too much ego to admit this is true, but you all know it is.
James Bond, I think if you honestly look at your relationships, you'll see that in some way you were a challenge. If not, you must look like a movie star. But, even that is no gaurantee that you'll do the right thing with women. I've had a lot of women compliment my looks, body, etc. But, I still screwed up, because I came on too strong. I kissed their butts, because I had no concept of challenge.
I honestly think challenge is very important if you're looking for more than a one night stand. But, like I said you can overdo it. It's something I think many guys need to practice. Like I said, I think your post is fantastic, but I think you underestimate the importance of challenge.