I guess it depends on what comes with the distro. If you start off with a basic Linux install and add a DE that is low on system resources, like LXQt, you can breathe life into a machine.
Bodhi, antiX and Linux Lite come to mind.
You can also start with a minimal base, Arch, Debian, Alpine, anything, and then add packages.