There are probably a couple interesting approaches. One might be to have users point some other domain at a Sandstorm API endpoint, end-running around Sandstorm's own domain, which might work in scenarios remote servers are only fetching. But another idea would be to sort of "special-case" an ActivityPub server deeply integrated into Tempest, and instead of letting a user install "Mastodon", they are installing a custom frontend that creates a user account on the server's ActivityPub.
Because Sandstorm was intended to work as a large scale hosting service, it avoided pretty much any design which could let one user know about another user on the server, but Tempest may end up making choices more suited to smaller deployments where we assume a Tempest server hosts either one organization or one family or one group of friends, etc.
Mailinabox [1] almost does it. They target Ubuntu stable, and upgrades are mostly silent. But they needed user intervention when Ubuntu had to be upgraded from 18.10 to 22.04, which was quite challenging.
If sandstorm can get there, then putting it into a RPi box is simple. What's difficult is helping the general public understand the importance of protecting their data, so such a product has a reasonable market.
One idea I think is really neat though is decentralized backup solutions, where an e2e scheme would work really well: Your home server could have a key to store encrypted versions on someone else's server (and vice versa for theirs). Losing a key would still be problematic, but only in the case you also have lost your primary server.
Sandstorm is an excellent project. I sort of consider it the platonic ideal of self-hosting software. It does everything the "right" way, especially with respect to security, but ultimately isn't compatible enough with the broader ecosystem for general adoption.
I've been wondering if a lot of self-hosting platforms are targeting the wrong level of scale. On one extreme you have single user instances (SUI hosting). The other extreme is centralized platforms like Google. I used to think the ideal for most people is the "nerdy cousin" approach, where each family has someone capable of running something like Sandstorm or Nextcloud. The problem is that I would much rather trust Google with my private data than anyone close to me. There's so much more incentive for them to go looking through my stuff. This makes me think SUI might be the way to go. Or maybe large federated providers, similar to what we have for email.