Yes, Social Media work very well but it all depends on which business category you are looking to generate leads.
Facebook works well for any kinds of B2C business and less compared for the B2B.
LinkedIn work very well & gives good leads for B2B - Enterprise Sales
Instagram works well for Fashion, Fitness related domains.
So categorize your need based on the Lead Persona and decide which works better for you.