You don't need to have big tanks to run sumps, you can run a sump on a goldfish bowl! But I know what you mean.
I agree with this,
At one point in WI I had a 50 gal tank outside for the summer, and used a 1,000+ gallon pond for its sump.

My preference is always using sump filtration for all my tanks, but I believe its sometimes the smallest tanks that benefit most, from sumps.
The increased water volume and larger area to grow plants can only help, especially if the small tank is overstocked.
For the tank in the pic above, I found having it outside, the day/night temp fluctuations became problematic, so adding the ponds large amount of water as a sump kept the small tanks temps less volatile
There also seems to be some variability in the ability of certain plants to make use of, and need nutrients.
A small amount of fast growing Salvinia seems hungrier and needs to be fed much more than a slow growing Anubias three times it weight (or size)
So choosing the proper plant for nitrate reduction for the job could be important.
Compact, and easy to control Salvinia may be the perfect solution for smallish tanks.
As it spreads, just compost the overage
But if there is room, Papyrus in a giant sump if the main tank is full of large fish.

The root ball of my Papyrus grew to almost half my 125 gal sump, and the plant stems themselves stood almost 5 ft tall.

I pulled the Papyrus a few months ago when mangrove pods became available.
There are now bout a dozen mangrove saplings growing in the sump, but their slow growth indicates their nutrient uptake may not make a big dent, at least at this point.

The photo above is 8 months of growth.
Mangrove tree pod washed up