Hi Joe, 

Content by itself will never pay the bills for 99.9% of creators. However content marketing associated to another business model does work at much smaller scale.

I've seen several of these business models work sustainably:

-Content marketing + consulting
-content marketing + financial services
-content marketing + merchandise shop
-content marketing + lifestyle products
-content marketing + niche products
-content marketing + porn 
-content marketing + video game keys
...and a million more.

I think the challenge is having the entire business model on Nostr + LN... but social media as the first step in a larger marketing funnel does work wonders.