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?
Yes it is possible. I never need the terminal. If you are interested, you can usually find a GUI way if you look for one. Some people just don’t look, then tell people there is no GUI for it. Not very helpful for newbies.
For those not into usability, different people work in different ways. Visual workers are not the same as text workers. So for some, CLI has poor usability and productivity. For lots of things I do, there isn’t a CLI anyway.
I use Kubuntu these days. It could be better.