From Google,
Here are some insulation requirements for warehouses in Houston, Texas:
City of Houston
City of Houston Minimum Property Standards (2)[1]
Exterior walls are to be provided with insulation and the minimum R factor shall be R-19 o...
The minimum R-factor for exterior walls is R-19, or R-15 plus R-5 foam. An air infiltration barrier, like Tyvek, must be installed on all exterior walls.
Roof insulation
The minimum R-value for insulation installed above the roof deck is R-30.
From your recent history of temperature swings... I would add another R-15 to the roof.
Heat always moves towards "cooler" surfaces and environments.
The bigger the temperature difference, the greater the heat transfer gradient.
In the summertime, your building will gain heat from radiation and conduction heat transfer.
Likewise, in the wintertime, you will lose heat from conduction and radiation.
You will also gain heat or lose it via convection heat transfer.
The most energy consumed by an AC, mini-split, or heat pump system is to remove the relative humidity at the given temperature (latent heat) before less energy is consumed to lower the temperature (sensible heat).
You need to have a blower door test done to determine how leaky your building is and to fix it.
You can be well insulated but still have heat and humidity migrate inside due to air leaks.
Get a Manual J cooling and heating calculation done based on what you have now and when you get the insulation work done to determine your cooling and heating loads.
Watch the R&R Building YouTube channel as the owner/operator built a big shop and went to town to properly insulate it.
He could probably cool his place down with a hundred pounds of ice and a ceiling fan or heat it with a can of Sterno... just kidding.