It's completely normal that you dislike being alone, it's healthy. Humans are social animals. Some folks can endure isolation better than others, but after a while it starts weighing on most people. So really, don't feel like it's a failure on your part. At the same time, don't let it get you down too much either. Once you're in a relationship, you'll fondly remember the days when you could do whatever you wanted, so make the most of it while you can.
With regards to finding inspiration from Berserk, Vagabond or other stories, I would caution you against trying to find "rules" in there to apply to your own life. It's normal to be influenced or inspired by stories, but keep in mind they're fictional and depict vastly different realities from our own. Besides, Berserk makes it pretty clear that being alone sucks. A huge part of the story is about Guts getting his priorities straight with Casca and then accepting new friends into his life.
Now, I don't know you so I can't really comment on your specific situation but I'll say that most people can be attractive enough to find a partner so long as they make an effort. That includes the physical side (hygiene, fitness, clothes) and intellectual side (be funny, kind, interesting, motivated). Some people have better luck at birth than others, but in most cases there's a way as long as you have the right attitude. That also means having realistic standards and understanding that a relationship is built on compromise and mutual care, it's not something anyone is ever owed.
Lastly, the truth is you're unlikely to find the love of your life on the first try. Rejection happens and when it does you gotta swallow it and move on, and even then many relationships fail and oftentimes badly so. It's a fact of life and it's important not to become jaded if it happens to you. You've got to stay positive and to generally be a fun and interesting person, because when you push people away they don't tend to insist.
To leave you with constructive advice: try to get out more and to meet new people. If you just stick around friends that are all in relationships, you may have less opportunities to meet a potential partner. Find some activities you like and involve yourself, whether it's sports, concerts, local associations, conventions, whatever. Get out of your comfort zone. The more people you meet (and get to know), the more likely you are to find someone. Good luck!