I'm speaking specifically about social media; like the one Google shut down because it wasn't viable. Facebook/Meta still don't make money for most their clients they simply promise returns and marketing depts have to utilize them because everyone else is and it's mostly fueled by leverage.
In my experience, advertising isn't worth it if you aren't a large corp. with access to debt and require a presence and even then it's mostly a loss leader.