For the longest time in my life, I was haunted and made shy by my social faux pas. The self-consciousness was ever-present. Then I realized that this was not so good. Basically, when I do something stupid, I get over it much faster now. I try to carry myself under the assumption that I'm worth being me, and that people will like me if I'm 1) clean 2) happy 3) friendly. It works. I'm ebullient, g-ddarnit!
The last time I had that dejected feeling was when someone asked me if I wanted to "pray" for anything. I was stunned. The query brought me back to being eleven years old, in St. Michael's Catholic Elementary School.
I think, as long as one has not done horrible things on purpose, and nothing really that bad, i.e. killing someone while drunk driving, then one shouldn't feel bad.
But then again, feelings like these could be medical, like indicators of depression. Therapy always helped me.