I have similar grocery run needs as you, including buying bottled water every week and often carrying up to 30L of other liquids. I do this on ip to two grocery runs using a standard cargo trailer. We soon will be a family and have chosen to upgrade our bike rather than covering to car ownership. Now, I have virtually unlimited grocery capacity (cargo bike plus trailer) while being able to also transport future kid soon.