Joe- I have found that vacuuming a VERY SMALL little tiny tiny part is okay if it is done like almost never, But IME, I have had nitrate spikes, diatom break outs and even bouts of Cyano, which I believe were due to stirring that patch of sand bed.
Once I stopped doing that, and got few different CUC critters (depending on the tank... I have a conch, hermits, various snails, bristle worms, maybe a SS goby if the tank permits) I never had to vacuum the sand. There just isn't a need.
I believe that the process of regularly vacuuming out sand beds will lead to vacuuming out important micro faunas that we all work hard to introduce to the tank. I think suggesting this would be along the same lines as telling someone to remove a small piece of LR and scrub it down every time they did a water change?
Again, this is just my experience and I have had a few tanks and a few substrates as well. The only one I vacuumed out was CC in a swim tank.
That is just me though. OP- You are certainly welcome to take all of the opinions on here and disregard them all, or try each one...