We study the asymptotic behaviour of isotropic and homogeneous universes in general scalar-tensor gravity theories containing a p = -rho vacuum fluid stress and other sub-dominant matter stresses. It is shown that in order for there to be an approach to a de Sitter spacetime at large 4-volumes the coupling function,omega(phi), which defines the scalar-tensor theory, must diverge faster than vertical bar phi(infinity)-phi vertical bar(-1+epsilon) for all epsilon>0 as phi ->phi(infinity)not equal 0 for large values of the time. Thus, for a given theory, specified by omega(phi), there must exist some phi(infinity)is an element of(0,infinity) such that omega ->infinity and omega'/omega(2+epsilon) -> 0 as phi ->phi(infinity) in order for cosmological solutions of the theory to approach de Sitter expansion at late times. We also classify the possible asymptotic time variations of the gravitation 'constant' G(t) at late times in scalar-tensor theories. We show that (unlike in general relativity) the problem of a profusion of 'Boltzmann brains' at late cosmological times can be avoided in scalar-tensor theories, including Brans-Dicke theory, in which phi ->infinity and omega similar to 0(phi(1/2)) at asymptotically late times.