Well, for example, where we live, we are not allowed to drain rainwater into the sewer system and are forced to install a cistern/infiltration pit.
In this case, an infiltration pit is probably required. However, a cistern initially has nothing to do with drainage, as it only serves as a temporary buffer. Once it is full, the water must be discharged 1:1. So if it is not mandatory, due to reduction, etc., I would have the additional cost for a cistern offered to me. Then you can decide if it is worth it to you. Regarding size, I would not go below 5m³, but also not over 8m³. In between depends on the application. If it does not really rain for 3 weeks in summer, you can empty a 12m³ cistern as well. However, this is rather rare in our latitudes. If it is also intended to regularly wash cars, bicycles, motorcycles, connect toilets, or refill the 10 fountains and ponds in the garden, then even 10m³ might make sense. For example, our pond easily holds our cistern’s fill, and water is changed there every 1-2 years. In addition, 200l-500l have to be refilled there weekly in summer.