MTW - That is very interesting.
On a budget, within the constraints of the existing building, I think the OP's best approach is a split strategy. That is, do whatever is possible to reduce the daytime heating - add shading, venting, etc. That helps the building and the air inside from getting...