Cabinetman (CM to me in the future), I just came across this thread today for the first time. I don't do the DIY thread very often because I have 4 tanks up and running for about 6 years (10-11 years in the hobby) now and don't see much chance of some DIY item causing me to do a big change. But you never know and I do visit here occasionally.
First, your video with you using the 'wand' to help stir and flush the sand is exactly what I did to clean used sand from a move. Only I did it in a 7g bucket and with a garden hose! So that looks very familiar to me.
Second, I run 4 tanks on 2 systems, 1 is 400g and the other is 200g. And between the 2 I run 6 filter socks. Now I don't mind changing them every 3 to 5 days, but it isn't something I look forward to either! And I have about 50 or 60 of them, so I hold the dirty ones in a big Rubbermaid tub with a lid in the garage until it's about full. That's roughly 30 to 35 socks. Then I flush them a bit with the garden hose and then run them through a double wash and rinse cycle in the washing machine. It's not that bad, but it's not fun either.
So, I like your sand filter system. It made perfect sense to me even before I saw the video, but the videos have also be a big help. Especially the one of the build before it had sand in it. How many gallons of water, in total, do you have in your systems? And roughly how many cubic inches or cubic feet of sand do you have in your filter? Or how big is the footprint and how deep is the sand? Since that's even better info that just the total cubic volume. Have you ever considered putting a filter sock at the effluent end of the sand filter for a day or a week just to see if it catches anything?
I'd like to continue to watch your progress while I start to organize my thoughts about setting up something similar. My 400g system has a 180g sump/refugium (8'x2'x18") divided into 4 chambers of 45g each. From left to right there is a refugium full of Chaeto and 2 filter socks, a DSB that is 8"+ deep, an evaporation and return pump section and finally a section with a skimmer with 1 more tank drain and filter sock. The 180g sps/lps reef drains directly into the AquaMedic Turbo 5000 skimmer by gravity. My 180g has a higher than average bio-load IMHO and I do tend to feed a bit heavy. If I set up a sand filter system, I'd keep the skimmer and a filter sock just as a check on how well the sand filter was working.
Thanks for posting this interesting idea. I'll be following closely and probably be asking more than a few questions!