It seems plausible to me that if you have decent air sealing in your house and wildly inadequate ceiling insulation then an attic fan could help. Or if you have poor air sealing but you have enough space for outside air to enter your attic.

In a well-built house, the roof and ceiling shouldn’t be a major source of summer heat gain.