I just add one to my 9 yo tank with a deep sand bed. He did a lot of work for a week. The first few days, I have a light haze in the water from him turning up the sand but now my sand is almost fluorescent white. The draw back is he is digging under some very old rock works and I'm kinda of concerned that he could collapse a critical rock. He already digged under a large grapefruit size brain. It was simple enough to fill the sand back in and leveled the brain out. However, if he undermines a large supporting rock, that could be trouble. I'm love the clean sand; but like you, I'm a bit apprehensive about him digging too deep. The good news is that when I set up my sandbed, I put a supported platform of eggcrate about 2" under my sand to prevent the rock work from sinking too low.
After a week, the haze has gotten a lot better. I think he turned up a few years worth of detritus in the first week and my skimmer is doing a great job of removing them. I think in the the long run, this will be better for my sand bed. BTW, I have a 6" sandbed that is about 9 years old made of Home Depot sand. This stuff is supper fine. If you have coarser sand, you'll be fine.