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.
After god knows how many years now of being on Linux exclusively, I tend to look at the terminal (commands in general) as a convenience more than a necessity. Meaning that in a lot of cases, knowing a command and quickly typing it to start an update (for example) is just faster and easier than pulling up the GUI every time.