Distros packaging software means that it is available to install with the package manager from their repositories. No distro provides every piece of software out there. This can be mitigated with Flatpak, Snap, GUIX, AppImage or, in a pinch, by compiling the required program yourself.
Sounds like you’ve already done most of the work. From what you’ve said, Fedora with Plasma sounds great for your use case. Good luck on your journey and glad to have you aboard!
I honestly liked 8.1 quite a bit - once I installed Classic Shell to not have to deal with the new UI. A first year usability student could have foreseen the massive issues trying to weld a touch screen UI and a traditional desktop metaphor would raise, but Microsoft for some reason were completely pig headed about making it work. It didn’t. It can’t. You can not staple two completely different UI paradigms together and have it work smoothly. Other than that, 8.1 was remarkably good experience for me. It felt really snappy under the hood. Good OS brought down by hubris. Well, good for a Windows release, at least. Use Linux.
3.11 was pretty good. After that it’s been a mixed bag. A bag of shit, but mixed.
I have also been very content with Posteo.
With low specs like that, the experience will never be great, but with a very light desktop you can make it work. Debian is fine, but with some set up, Alpine could be one option. It’s a really light distro.
Turns out this is also available in Alpine repositories, so I went ahead and installed it on my phone. Could come in handy when browsing from public Wi-Fi or such. Thanks for the tip.
I turn it off every night or if I’m away for many hours, so about 10 minutes right now.
I do have a Raspberry Pi that’s been up 12 weeks, 5 days, 19 hours, 59 minutes. I believe there was a planned power outage when it was lasted turned off.
You can do a really slim install of Debian that should work. For DE I recommend LXQT.
If you’re feeling adventurous, Alpine might be slightly lighter. It’s a good distro.
Those specs are not going to get you a terribly fast experience, but my laptop runs Debian ok and it’s in the same ballpark.
I can second Posteo. Functional, affordable, FOSS, ecological and private enough for my needs.