If Rhythmbox, libimobiledevice, usbmuxd (and I believe a few other MTP libraries) will build, as well as
gThumb and something like
PCManFM if need be, that would in theory enable near-comprehensive syncing to modern iOS devices, sans the software restore functions exclusive to macOS / iTunes. If
cups and
cups-filters build, that would also restore compatibility with modern printers.
Likewise if something like
Geary or
Claws Mail will build, that would also supplant Mail.app as a modern email client. And if
surf and its libwebkit2gtk / libjavascriptcoregtk dependencies will build, that would also fill the place of Leopard WebKit / Safari as a both lighter and non-Rust modern alternative to the Mozilla browsers -- assuming the hardware abstraction layers work and it can use the GPU.
If Snow Leopard is already actually that capable, perhaps there is a future where it can act as an effective intersection of OS X and Linux offering the best of both worlds, once the bugs have been ironed out providing all of the elusive hardware compatibility of the former (working sleep, X1900 compatibility), together with the coveted modern software access of the latter. In that case there would no longer be almost any need to spend time exploring Linux (troubleshooting a broken GRUB / missing kernel modules / strange trackpad response / etc) for the vast majority, unless security of the OS itself is a high priority.
But if the kernel and all AOSP frameworks, libraries, and applicable binaries can be rebuilt to modern versions, that then resolves a significant chunk of the security factor albeit likely at the progressive cost of stability. But at the same time that would be such an undertaking, it is almost a completely different project altogether; given the factors you cited of most people having limited time / resources, I can't imagine anyone would actually take that one on.
Completely agreed (this and everything else). If the bugs in Snow Leopard can never be resolved given many kexts and frameworks are nonetheless closed-source and / or do not function properly with equivalent imports from 10.5.8, this would by far be the next best route.