Recent advances in algorithms and computational hardware have enabled the calculation of excited states with time-dependent density functional theory (TDDFT) for large systems of O(1000) atoms. Unfortunately, the aqueous charge transfer problem in TDDFT (whereby many spuriously low-lying charge transfer excited states are predicted) seems to become more severe as the system size is increased. In this work, we concentrate on the common case where a chromophore is embedded in aqueous solvent. We examine the role of exchange-correlation functionals, basis set effects, ground state geometries, and the treatment of the external environment in order to assess the root cause of this problem. We conclude that the problem rests largely on water molecules at the boundary of a finite cluster model, i.e., "edge waters." We also demonstrate how the TDDFT problem can be related directly to ground state problems. These findings demand caution in the commonly employed strategy that rests on "snapshot" cutout geometries taken from ground state dynamics with molecular mechanics. We also find that the problem is largely ameliorated when the range-separated hybrid functional LC-$ømega$PBEh is used.