Drop in visits seem to be only half an hour, and day care only in sitter’s home. Why?

Yes. While I don’t where you’re located, I believe that there would be a sitter near you that would be willing to do an extended visit for your dog. My recommendation is to read through the profiles for sitters who say they have experience with separation anxiety dogs. Then message them and find out if their schedule allows them to be with your dog on the date(s) needed. In my experience, sitters who do regular dog walks, or have small kids, go to school or another job generally do not have the extended availability you’re seeking.