Immich is a promising self-hosted alternative to Google Photos. Its UI and features are clearly heavily inspired by Google Photos, and like Photoprism, Immich uses tensorflow-based machine learning to auto-tag your photos!
Mastodon is a twitter-inspired, federated, microblogging community ("social network"), which anybody can partricipate in by joining a public instance, or running their own instance.
The answer (to "what's sexy on the outside, and boring(ly) reliable on the inside?") is..
.. Nextcloud 24, which I reviewed this week, while modernizing the recipe. Read on for details...