Does painting roof tile improve longevity or performance?
Simply using paint is a cosmetic application. Using a silicone or other sealant based paint would actually improve water protection. If the goal is to seal the roof then it might be a good idea to apply silicone sealant and then paint. For cosmetic applications, any outdoor latex or acrylic would do just fine.