Has this happened at the same time of year before? Maybe it's "normal" for a cactus to droop mid-August. I know I usually do.