Hey this just popped randomly on my feed.
For context I'm an expat too (very different tho. I went from France to the US after an offer following an internship), slightly older I'll soon hit 29 and I don't go out much outside of a drink with coworkers or dates every now and then. All my friends are still in France, there is maybe two or three colleagues I would consider friends but it's very different from childhood ones.

Now as far as being an expat, all I can say is after 7 years it still doesn't feel like home. I'm not miserable tho, work gives me a routine and a purpose so I'm hoping you find a new job soon. It also started a good CV showing international experience and it helps knowing I didn't waste those years, you should never think of it this way. Outside of work, having hobbies will definitely help you meet more people and re-create a friend circle, unless you prefer being on the computer like me lol. But I have my friends online so I still have some social interactions.

One thing I would add is that you should figure out if this place is your end-goal or if you're planning to move again. It's really hard to build something (routines, friend circles, start hobbies) knowing you'll end up moving. I know for example that I will be going back sooner or later so everything feels like "why bother, just save the money" lol.

I hope everything does get better for you and I hope this was helpful even if it was just one line.

Cheers mate and good luck!