This is one of those things where I think people really overthink it. Sometimes there is a particular reason to use one distro over another, such as a focus on gaming or vendor support, but otherwise, just pick one. In most cases it isn’t going to matter much.
It’s not 1998, most things are distributed as binaries. I use many out-of-distro applications like Zoom, Microsoft Edge, VMware Workstation, Google Chrome, Microsoft Defender, Crowdstrike Falcon EDR, RStudio, VS Code, and various random things downloaded from github or dockerhub that are all ready to install or use binaries.
And for me, in scientific computing, stuff coming as source code makes Linux by far the easiest option. Often it is as easy as git pull ; make. Sometimes I might need to do apt install to fulfill a dependency.
That gets back to the exact same hangup people have. Do you need a word processor or do you need MS Word? Do you need an image editor or do you need Photoshop?
If you absolutely need a particular piece of software, then you are locked into whatever operating system that software runs on.
The debate is always about whether someone needs Excel, or if they just need a spreadsheet, and only think they need Excel. Most of this is rigidity and fear. When I need help with writing some formula in Libreoffice, an answer aimed at Excel is almost always going to work to solve my problem, I just need to realize the button I click on looks a bit different.