Is it over?

How does anyone connect to anyone in today's world? Seriously I don't get it. Everyone 'likes me because I'm super sweet caring and friendly' or something along those lines but then never want be anything more than my acquaintance. I've lost hope, I can't even picture myself ever finding love anymore. If I'm still around in four or so years I might just adopt just so there is another human in my life as selfish of a reason that is. I just want friends at this point but that is somehow also starting to feel unrealistic. In the 19 years I've been alive I have ever only had one friend (goat). I don't know what to do anymore. I've tried dating apps, talking to people at work, going to the clubs at my local collage, literally just sitting down and trying to look friendly in public places. People with friends, how do you do it? I know this isn't exactly a dating question but I don't know where else this would go