I use the black Norwesco tanks from Tractor Supply. They are rated for potable water, and are, in my opinion, excellent. I have not seen any algae in my tanks and they sit in direct sunlight. From another poster's comment. I am a big fan of metal roofs for many reasons. I would choose the Galvalume Or Kynar coating if using for drinking water, and also test regularly for metals.
This is just me, but I won't touch water from a shingle roof, I only use that for mixing concrete, mopping floors etc. My one regret with my place is that I used shingles for the main roof. All construction since then uses metal.
I can't back it up , but my intuition would be that if I were to paint a water tank, I would use white paint, perhaps that will not heat the water up so much (unless you want that). But I hate painting so I just leave them alone
https://www.norwesco.com/products/above-ground-tankshttps://www.extremematerials-arkema.com/en/product-families/kynar-pvdf-family/regulatory-status-2/