I have used Arch for >13 years (btw) and use the terminal every single session. I also work with Linux servers daily, so I tried the other families with DEs (Debian/Ubuntu, RHEL/CentOS/AlmaLinux/Fedora).
I’m comfortable (and prefer) doing everything with CLI tools. For me, it’s a bit difficult to convert my Windows friends, as they all see me as some kind of hackerman.
What’s the landscape like nowadays, in terms of terminal requirements?
Bonus question: Which distribution is the most user-friendly while still updated packages? Does anything provide a similar experience to Arch’s amazing AUR?
Hell you can use Arch without the terminal if you really wanted to. CachyOS for example uses Octopi which is one of the few Arch Package Manager GUI’s that support both Pacman and AUR. so in that case you may never really need to touch the terminal and Octopi is preinstalled with CachyOS.
Other than that Fedora KDE or Bazzite are good options. But yeah there are few Distros where you really don’t need to use the Terminal if you don’t want to.