Freshwater is less of a concern regarding size compared to saltwater. Those salt people need skimmer space, refuge space, perhaps DSB space, etc.
For freshwater IMO you really only need to consider 2 things. First, the sump big enough to hold all the filter media that you plan on using (both mechanical and biological).
The second is that in the event of a power outage, you need enough empty space in the sump so there's room for it to fill up before the syphon is broken with the display tank, otherwise you'll get water all over the floor. To some extent this makes sump size a concern, but it also is impacted by how full you keep the sump normally. For example, if the water level needs to drop 2" before the overflow/bulkhead stops draining from the main tank to the sump during a power outage, that's 2"x24"x72" worth of water to account for in the sump, or ~15 gallons (~14.96 US gallons for anyone who wants to be more technical). The exact amount for your setup will depend on your specific circumstance.
A 4' long tank would probably be nice and roomy, but I suspect you could get by with a 3' tank if necessary. Anything smaller and I suspect you'd find it both cramped and not capable to handle the excess volume during a power outage.