I agree. There have been many times when I have regretted being overly honest and revealing about myself. People tend to hold it against you.
I think it is a good idea, however, to reveal a minor fault, which tends to humanize you and makes you relate-able. Usually women find this kind of thing cute and kind of tugs at their heartstrings. Perhaps it's a shyness in one small aspect of life. It should be in a very narrow field, not an overall insecurity. In general, though, we need to present our best selves to women. They are hard-wired to respond to a man they can look up to, and submit to. She would rather see you posture and strive to live up to your highest potential, than to openly talk about your insecurities or weaknesses. She will not mind those weaknesses if your striving to overcome is there. In a woman's mind, the striving cancels out the fault, just as in her mind, ambition cancels modest financial means.
The unspoken agreement is "If I see you striving to overcome the weaknesses that I can intuit in you, they won't bother me." Not in so many words, of course, but that is her feeling. In this way, even your weaknesses can cause her to admire you even more.
Never, ever, EVER turn her into your therapist. That has killed a multitude of relationships, and that dynamic can creep up on you real quickly in a committed relationship.