You don't need to have a direct LN connection with the content creator, just a path through intermediate nodes.

More likely users won't have to deal with all that because there will be micropayment wallet providers that can aggregate the transaction costs of buying bitcoin and maintain large value LN channels.