I just wanted to say, I'm sorry to hear that happened to you. I personally think reaching out is quite difficult, as I have to deal with social anxiety popping up quite a bit. So it's awful that you ended up in a situation like that. I lurk here mostly but your posts are very thoughtful. I hope you get the will to try again in the future. If you'd like someone to chat to just ping me in-game.
I've had a similar experience regarding making mostly acquaintances. I had met a couple of people while going through the MSQ that really pushed me further. The first one was when I was just a starting arcanist. I've always had a bit of trouble getting past the first phase of MMOs, where it feels like there isn't as much you can do. That person and I were both attacking a goobbue together, then one of us reached out and we went through the rest of the quests. They definitely helped me get more engaged. The second person and I met at the end of ARR and eventually ended Heavensward together. Unfortunately though after that our schedules didn't match up as well. Still, it was nice to go on that journey together. It would be nice if there was a way to do more of the MSQ together with someone.
Recently I've made about three friends, though it didn't come easy, and who knows if that'll continue. I've noticed that most people tend not to reach out to me, it feels like I have to initiate conversations typically. Otherwise they'd just be another person on the friends list, that I might not remember in a few weeks. I'm not sure why that is. It can be discouraging sometimes to feel like I'm the one who has to put the effort in. I guess it might be that they want to escape the social pressure, or maybe it's just awkward to try and start up a conversation after the first meeting and most people won't try to. It feels like the step from that to a more substantial friendship isn't an easy thing, I haven't figured it out yet. It does sometimes work out though, at least from my recent experience. I feel it requires a lot of effort, and building up courage/resistance to handle rejections, at least for me.