I use tumbleweed. It's like Arch but without the blood. I need a bleeding edge distro that's preconfigured for sanity out of the box and just works. If you do too give it a go.
I open Discover in KDE Tumbleweed, search for the SW I'm looking for, click Install, and then type my admin password to confirm. Don't even need to open the command line.
What did you find difficult in that?
Packages that aren't native to Tumbleweed are available in Discover as Flatpacks.
You're probably trying to look for software "the Windows way" of downloading the sw from a website in which case you mostly see .debs and .rpms but that doesn't mean it's not available in the tumbleweed repos or Flatpacks if you search Discover.
Niche stuff not available in the official repos or Flatpacks can be found in the OPI(similar to Arch AUR) where the proprietary codecs also are.