Scalar-Tensor Theories for Dark Energy and their Cosmological Consequences