A negative ROI (return on investment) suggests it won't pay for itself ever, be that in cash or carbon.
If you're actively trying to cool the building then painting it in something that lowers the energy needed to cool it. And as were just talking about paint, carbon and cash cost is likely to be low relative to savings.
So no, painting all houses in this stuff might not reverse global warming, but that wasn't what we were talking about.