You are welcome and thanks for writing me such a detail reply.
The bigger floor area theory is assuming the shrimp will pick on the substrate. What I had been observing is that it works better to have more space for microbial and zooplankton to hide; this is the reason why some strong shrimp will dig deeply into the substrate. Hence, it is not necessary to have large surface area. I did aquascaping for all my tanks. Surprising, they love to pick on porous rocks and driftwood more than on the substrate, except when I am feeding them powder food. If space is a constraint for you, then there is nothing much you can do. ;)
Are you planning to have those shrimp only tank with just substrate and a few mosses? If yes, you may want to hear my recent experience. Recently I setup a tank that has a little aquascaping but it is kind of "open concept". My shrimps hate it. It is like there is no place that they can rest and feel safe. End up, all of them will go to some corner of the tank to rest or sometime hide under the shade of the water outlet. As such, I am concluding tank that is too open is not conducive to shrimp. End up, I think I will tear it down and redesign the scape. Below is the tank design they hated very much:
I have this problem of treating my shrimps like my pet, such as dog or cat. Hence, I will try to give them the best life. As such, I may be overly pampering them when compared to other people. LOL!!!
Regarding the overflow, I forgot to mention something. Are you placing this tank is living room or somewhere noise is a concern? Overflow can get pretty noisy. One way to reduce the noise is to add a ball-valve to the overflow. Add it where it will be parallel to the water level. Leverage on the ball-valve to control the flow rate such that the water level reaches about half of the hole. In this way, you will be able to cut away 90% of the noise. By the way, be it the overflow is from bottom or from the back, you will still need removable coarse sponge to cover the hole. Last time I only cover my overflow with mesh. End up, I get like 50 babies/teenage shrimps in my filter sock every week. LOL!!!
For the outlet, make sure it is facing away from the overflow. In this way, the water will circulate nicely from the top and down then back to the overflow. In addition, you need to make it moveable such that you can adjust the up and down angle freely. This will help you to adjust the angle of the water stream so that it achieve the maximum water surface agitation. With slow water speed, the water surface agitation is not meant for aerating the water (you need to add air-pump & air-stone in the sump), it is more for removing bio film. Usually with overflow, it will skim the biofilm. However for shrimp tank case, we need to cover the overflow with something (I suggested coarse sponge) to prevent shrimp swimming into the overflow. Once the overflow has less than 2cm width, the biofilm will not be able to be skimmed.
Sounds good on your ATO plan. Just make sure you get a reliable solenoid. ;)
Here is a picture of the front-side view of the sump tank but I think can't see much (Ignore the activated carbon. I usually use activated carbon during cycling):
Here is a picture of the sump without water:
By the way, how tall is your cabinet? If it is very tall, you can consider building a trickle filter. Basically, you will have 2 levels of sump tank (totally segregated). First level is the trickle filter and the second level is the consolidation/reservoir sump tank. The good thing for trickle filter is that all the filter media are not submerged, thus less waste material will be dissolved into the water. In addition, it helps to aerate the water too.