Yes and no.... I joined a few in first year and one of them I was quite successful in, however lack of effort from both sides meant it fizzled out. Others I just turned up for the activities and didn't make any friends.
I struggle with making friends anyway so perhaps it's my fault rather than societies....I think it does depend on the society though as they are, as said, run by 2nd and 3rd years who get all their friends to join, but sometimes it makes it cliquey and other times they are welcoming and opening to new people.