It's a matter of a space being able to 'breathe'. While increasing insulation will reduce heat gain to a space it will also reduce heat loss to a space.
Say your system is a space with exterior ceiling, floors, and walls, and typical office internal loads. During unoccupied hours when the sun is down $Q_{in}$ is probably pretty small and less than $Q_{out}$ with a roof insulation of say R-30, so your space will cool. Now when that's increased to R-34 we'll assume that both $Q_{in}$ and $Q_{out}$ are reduced by 5%, and since $Q_{in}$ was smaller than $Q_{out}$ $\Delta Q_{in}$ < $\Delta Q_{out}$, so the space will cool less than the previous situation. Where this becomes tricky is when you've increased your insulation to a point where you're now trapping all the heat from your internal loads inside the space such that it can't escape at night when it was previously able to.
Somewhat of a duplicate question, someone else can be the judge though.