Do you guys actually produce profitable ads?

Two drop shipping business started and failed. I'm not gonna give up as the model seems like it can work, as long as this one aspect is true...

Has anyone actually made social media ads which convert for a higher profit then spent. Basically CPC is lower than profit per conversion.

Or is this a very rare instance, most ads run in negative profit.

I need to ask this question and find answers before I start my next store, as I believe this is fundamental to the system working. If running social media ads like this is now virtually impossible, I won't be pursuing another store.

If you could share your stories and if running profitable ads is still viable for products. Thanks!