I recently filled a window seat with potted plants, mostly succulents. The last couple of days something's been digging into plants, mainly an aloe vera. This isn't a small hole, almost half of the soil in the pot ends up next to the plant. Whatever it is also knocked a jade plant over. No signs of droppings or anything else disturbed. Please advise.
It's the 21st century. Odds are excellent that you have something that records video, possibly many such things, some of which might be obsolete, but still capable of recording video (looking at you, old cell phones and tablets.)
Set one or more such things up with the video recording adjusted so that it can shoot for 8 hours or more, provide enough light that it can see, review the video in the morning.
Given the time of the year (assuming you're in the northern hemisphere), the creature is either a mouse or, more probably, a shrew. Shrews are carnivores, so if that's what this is (and I think it is), then its looking for buried insects or earthworms. This is especially the case if you've had those pots outside during the summer. Shrews resemble mice but they're a darker brown and have an elongated, very pointy nose. In my experience, shrews do not damage much at all when in a house, unlike mice.
Mice are easy to eradicate, but shrews are much, much more difficult because they're smarter. I've had one in a house in the past and tried a variety of mousetraps - including one setup where I had a baited mousetrap surrounded by non-baited and set mousetraps. The shrew popped every single non-baited trap, then popped the baited trap, then ate the bait. I only caught him when I used a small live-trap. I let him go near a woodpile a mile away because he was a worthy adversary. Not sure who actually won that battle, but I suspect it was the shrew (free transportation to its desired home).