I am posting a second answer rather than editing my first answer basically just because my first answer is wrong, and this answer is just going to present some data and then make the opposite claim of my first answer.
I ran some calculations using Molpro on $\ce{H2O}$ using a number of different basis sets. Molpro, conveniently, actually prints out the Virial ratio, and I believe it prints this as $\frac{\langle T\rangle}{\langle V\rangle}$ (as opposed to the other way). So, after optimizing the water using each basis set at the HF level, the ratio was found. Note that HF was used because finding this ratio for post-HF methods is much more complicated, and I believe that in the case of post-HF methods, my first answer actually would be correct. Namely, the ratio should no longer be -1.
\begin{array}{cccc}
\hline
\text{Basis}& \text{avdz} & \text{avtz} & \text{avqz} & \text{6-31g} & \text{6-31g**} & \text{6-31g++} & \text{STO-3g} \\ \hline
\mathrm{Ratio} & -1.00080 & -1.00051 & -1.00008 & -0.99961 & -1.0008 & -0.99919 & -1.00600 \\
\mathrm{Deviation} & 0.00080 & 0.00051 & 0.00008 & -0.00039 & 0.0008 & -0.00081 & 0.00600 \\ \hline
\end{array}
Note that in the above avxz (x=d,t,q) is the aug-cc-pvxz basis set.
So, it does seem that with the correlation-consistent basis sets, the deviation from a ratio of one decreases as the basis set becomes more complete. The Pople basis sets don't follow any trend that I can see. STO-3g is the worst which makes sense cause it's the worst basis set.
I would suspect that these differences are not significant. I think this actually is a reasonable method of determining how converged a HF geometry is, but I am suspicious that something else is going on here. I don't know why there would be deviations. The only thing I can think of is intramolecular BSSE, which is rarely talked about because it usually doesn't matter, but maybe this measure is sensitive to it though. I kind of don't believe that though so I don't know what's going on. I guess one thing to try is to look at this ratio for a system which is known to suffer from intramolecular BSSE.
The only other thing I can imagine is the boring answer (but is probably right) that converging the total energy and the gradient, which is what are usually converged in geometry optimizations, does not converge the kinetic energy beyond the third-ish decimal place, so we see deviations.
As to your question of how much tolerance we should have for this, my guess is that the amount of tolerance we have now is sufficient because otherwise people would have figured out what was wrong and fixed it. That is, there is no obvious error in QM calculations that can be traced back to disobeying the Virial theorem. I would guess the reason for this is that usually post-HF methods are used anyways, so any effect of slightly disobeying the Virial theorem gets washed out because the geometry at higher levels is different from the HF geometry. Whether or not this same deviation is seen at higher levels of theory is something I don't know and would be trickier to answer.