This is why I gave up on being arsed with 'friends' some years ago. I am middle-aged now, (late 40's,) and have not bothered with friends for about 10 years. Basically, because all I got was shit on, let down, used, picked on, tapped for money and favours (but rarely got anything in return,) jealousy and bitterness and catty remarks, snide comments coz my kids did better than theirs in school, copying/trying to out-do me (and DH,) being nosey, gossiping about me (and others,) and just generally pissing me off and irking me, and draining me and boring me with their constant problems that were ALWAYS bigger than mine.
I'm not saying I am a better person than any of them, but I got bored and fucked off with 'friends' by around the age of 40, and decided I couldn't be arsed anymore. I know it's probably not an ideal way to live for some, but it works for me. Yes, I have less people to depend on, but at the same time, I don't have people bugging me, boring me, and pissing me off for a myriad of reasons.
Oh I am friendly and civil with neighbours and have friendly acquaintances who I strike up a conversation with in town, or in my village, or at the pub, and I chat freely in a couple of hobby groups, but actual friends??? No thanks. Friends are overrated, and a pain in the arse.
I have had, on a number of occasions, women try to strike up a friendship with me in the past 9-10 years, and have lost count of the amount of times I have been asked to their house for dinner, or a drink, but I always politely decline, and always keep them at arm's length. They are always puzzled as I am outwardly pleasant and friendly, but that is as far as it goes. I do not want to be their friend.
I know I sound like a twat LOL, but it's incidents like what happened to the OP, that has made me like this.