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?
I cannot vouch for every distro and every use case out there, but for me, yes you can daily drive without having anything to do with terminal. Some distros have worked a lot ensuring this.
I would recommend to start with Linux Mint.
I agree. In my opinion Mint is one of the few distros that actually manage to make everything doable without the terminal.