DietPi! It’s one the most resource efficient distros that is easy to set up. It’s ideal for single board computers and virtual machines, so I use it as a low-overhead Docker host on my Raspberry Pis. The dietpi-software tool installs optimized versions of most software you might use for SBC projects, but if it doesn’t have what you’re looking for, you can also use APT to install packages from the Debian ARM/ Raspbian repos.
When I install Linux for friends and family the only distro I use anymore is Fedora. I have used just about every major distro, and Fedora is the only one that has “just worked” on every computer I have tried it on.
Love them, or hate them, Red Hat is by far the single biggest company in the Linux community, and their Red Hat Enterprise Linux is renowned for being stable, performant, and very well supported. Fedora is where most of the updates that make their way into RHEL are initially available, so with Fedora you get a cutting edge distro with the backing and resources of a massive corporation that employs many of the top Linux-desktop contributors.
If you want a distro that “just works” I strongly recommend you give Fedora a try.