I have a flat, foam roof, painted white. It really does work to keep the house cool, although the flat roof geometry would be problematic in climates with more precipitation.
I suspect roof paint will be much less important in coming decades as solar panels proliferate, however.