“ Unfortunately not enough space to partition it off very easily”
As I understand it now, there is no attic space. You could, as an experiment, partition off the ceiling space, maybe using silver reflective tarps, ventilate that with fans, and see if that lowers your temperature.