It becomes more complicated when dealing with a massive tank. I had a sump first and it was a pain. Sizing the sump with pump flow and tank volume can be a problem. Basically, if you have a giant tank, you'll need a giant sump. Or else when you turn your pumps off it will overflow.
For example, my tank was at 1600 gallons with a measly 90gallon sump with just one 2400GPH pump. (needed two pumps, but could barely get one to balance with the sump--no issue with canisters) This meant that the tank water height would be around 4 inches higher than the overflow (on my system). Well, that four inches would take 5 minutes to drain back into the sump and this volume was around 250gallons. So basically, if I lost power, my sump would seriously overflow. I had overflow safeties, but neither those or even my sink and drain would keep up with that 250gals that drained in 5min.
Yeah, if I had a 500gallon sump or so, it would have worked. If you have the space, go for it. Otherwise, expect a balancing act on volume/GPH. And you better and a huge drain to accommodate the flow in an emergency as well.
Personally, once I went with closed loop system, it was a huge breath of relief. Turn off the power and all flow stops. Period.