I’m gonna go against what you said about drinking and say: it’s absolutely more fun if you have friends to drink with. Just because it wasn’t fun with your brother and his friends - well, they might be a bunch of sorry drunks who would not be fun to drink with anyway. 


If you have a group of really great, trusted friends, who are also ok drunks then it is a lot of fun. 


In general, people like alcohol because they want to forget their problems, to relax, and to feel less socially awkward/joke around etc. 


However, if you don’t like it, you really don’t need to look for reasons to start liking it. You’re absolutely better off not drinking, health-wise. A lot of people are alcoholics and they don’t even realize it, which is a very sad truth.