These days, it is totally feasible to have the best of both worlds with a niche distro that is exactly what you want and Distrobox with another distro to easily bring in any software that you miss. Distrobox totally solves the compatibility problem.
For example, you could have a MUSL based distro like Alpine or Chimera Linux as your host OS. Need software that does not run on MUSL? Just install a stripped down Debian image on Distrobox and “apt install” whatever you like.
A few weekends ago ( just for fun ), I installed Red Hat 5.2. Not RHEL 5, real Red Hat 5.2 from before the Fedora days. My idea was to build Podman and Distrobox on it so that I could get access to the current Arch Linux repos ( and AUR ). I got a bit lost in dependency hell and did not quite get there but I was close. I might try again sometime.