Can I tell whether my loyalty programme is paying for itself?

Yes, from the Reports tab of the card screen in Marketing. The number to watch is what card holders spend against everybody else, along with orders placed after somebody added the card. If those two are not moving after a couple of months, your reward is too small or too far away.