The sad thing is, that if people stuck around long enough they would see that I'm just quite soft and insecure and would make a loyal and very good friend
Nope. They have no obligation towards you at all. You're the one who wants to make friends, you're the one who needs to make the effort - to 'present yourself' in an appealing way, listen to them, offer something they want (most people have friends already, what is being friends with you going to add to their lives?), basically, befriending them.
And of course that's not like a sales pitch really. It usually starts small and grows. Sometimes only to a 'friendly acquaintance' point, sometimes to full friendship. How it goes is so hit and miss, depending on circumstance, as well as perosnality, need and willingness. So you do have to keep trying, with lots of people, and not expect anything of any particular person.
You sound quite dismissive of others. You make a little effort, it's not good enough for them, you find them annoying, you dismiss them. That sounds really high-handed, closed and rather arrogant actually, the way you've written it (which may be far from accurately portraying the truth of course).
I think it's rather like dating. You have to present openness, a willingness to try something new, an active interest in finding something involving other people, finding out more about them. 'I'm here, take it or leave it' won't achieve that.
Your references to buying things just sounds materialistic to me. To me, not everyone, that signals dull and shallow. Not someone I'd want to get to know. I do know one or two people who talk a lot about 'stuff' and do come across as materialistic (they are), one as quite braggy too but, I regard it as a funny quirk, or just a difference in outlook, because I know them to be intelligent, interesting, insightful people, who are good and loyal friends, as well.
Sorry that sounds rather negative. It's honest feedback on what you've written, which won't be the whole story. Pps have given great advice.