A few people I knew at uni would go out on their own a lot if no one else could be bothered to go out. They were the sort of people that would go out on their own, and come back with a new group of people who they'd never met before and probably stay really good friends after
I wish I could be like that to be honest, the confidence to just go meet new people the way they did, so I guess in response to your question, it depends on the type of person you are
If you just wanna go sit and have a drink on your own all night in a club then yeah you'd look a bit silly, but if you wanna go out and just see what happens, meet new people, then yeah it can be rewarding