Yeah, Debian was designed for the old-school multi-user days where a system was maintained by a dedicated sysadmin. Ultimately linux people will be dragged kicking and screaming onto something with sane library management like NixOS (or else something Snap/Flatpak-based, but I hope not), but it hasn't happened yet.
If I had the time, energy and funds I'd try some mix of Ubuntu (driver supports always been really good OOTB with Ubuntu for me) with something like NixOS package management maybe. I just prefer my distro to be decent OOTB instead of me hacking up solutions.
