Have you looked at installing a attic fan to pull air from the lower floors upwards into the attic for venting? I recall This Old House doing a segment on this some time ago and a cooling option.
(edit) added link to youtube video
(edit) added link to youtube video
Doing this will even make your AC system work better if you have one, since you won’t have the extremely hot air in your attic heating your ceilings
https://www.energyvanguard.com/blog/75600/The-1-Reason-Power...
A whole house fan is a very different story, but it’s only really useful in some climates.
In a well-built house, the roof and ceiling shouldn’t be a major source of summer heat gain.