What if it takes decades or centuries to pay off for society and perhaps never for the individual (in strictly monetary terms)? How should these things be funded?

Could also look the other way around: if things pay off anyway, why should should tax payers fund it?