that's official... I get about 2500 m^3 of fresh water here. I won't need that much in my garden in my lifetime...
If you "only" have a lawn, probably not. We have several beds and a greenhouse, so it adds up. Unfortunately, I can't find reliable numbers quickly, but with roughly estimated 150 m3 of garden water per year, it takes about 15 years for the cistern to pay off. Since we are building new, that is actually at least our goal.
However, the cistern would always have to be optimally filled and nothing should seep away, because with 700 mm of rainfall per year and 200 m2 of roof area, only 140 m3 of rainwater will arrive – and not only in the summer, when we need most of the water. So if I calculate with 100 m3 of usable rainwater, we're already looking at over 20 years to break even... then it somehow becomes unprofitable.
Maybe it will only come down to rainwater barrels and fresh water out again :-/