Sorry for the late response, I got caught up in a whole web of things.
I can only comment from my personal experience: I have been using Arch Linux as my daily driver since 2023. I too, got sick of WIndows. This was before I got into (PowerPC) Macs even, but I had some experience with FreeBSD.
I've primarily been running it on a ThinkPad T520 and it has been mostly smooth sailing so far. My system consumes very little RAM on a graphical session and feels quite performant for a 14 year old dual core. The same can be said about ArchPOWER on a G5 Quad, it feels quite snappy really. So I don't know why people are calling it fat and slow, it certainly doesn't seem that way to me. But the unfortunate reality is that as systems get faster and more complex, all software is getting more bloated.
ArchPOWER is mostly maintained by a single person so the amount of packages is a bit limited compared to other more mainstream distributions but Adelie Linux has a very limited package count as well from my experience. Adelie Linux is also kind of a nonstandard Linux distribution with the musl standard c library so it's a pain to compile software for it.
So, regarding packages and modern web browsers: ArchPOWER does have it's own repositories with a pretty decent selection of packages:
https://repo.archlinuxpower.org/base/. A small selection of additional packages provided by a community member are here:
https://github.com/techflashYT/archpower-extra-pkgs/
These will let you setup a full KDE, TDE, Xfce or IceWM desktop. In regards to modern web browsers there are phantomsatellite-gtk2 (Pale Moon fork) and the various webkit based browsers (epiphany, midori, vimb. But webkit has been hit or miss for me on ppc64, which is one of the reasons why I run the ppc6432 iso). There is a ppc64 only Firefox package but I was unable to get it to work, I think it requires a newer POWER ISA. Only Debian has gotten up to date Firefox running on ppc64 G5s unfortunately. Chrome is a no-go, it is very hard to compile, takes an eternity to do so and needs a lot of patches for our old Big Endian PPC/POWER systems.
My browser of choice is phantomsatellite with the noscript plugin because only TenFourFox and it's derivatives have a JavaScript JIT compiler for PPC. Expect JavaScript to be very slow on Linux, but actual page rendering and web compatibillity should be miles ahead of MacOS because TenFourFox/Interweb/Aquafox are just very dated at this point.
There is also a gimp package but it is still based on gimp 2 because gimp 3 does not work yet. And gimp 2 crashes when loading in an image but once you restart the software it will recover the image and you will be able to edit and save as you please.
So no, you can get quite far without compiling from source.
But, and this is where I think the power (no pun intended) of Arch really comes into play: it is very easy to compile your own packages in case you do need something that is not in in the ArchPOWER repositories. All Arch Linux packages, whether it be official ones or unofficial ones from the AUR, are in their original form distributed as PKGBUILDs, basically a recipe on how to compile a package which gets parsed by makepkg, part of Arch Linux's powerful build system.
Since ArchPOWER hardly differs from regular Arch, you can often just retrieve an x86 PKGBUILD from where you prefer and build it locally for PPC with the makepkg -Asi command (the A flag ignores the architecture listed in the PKGBUILD). Hence I do have a lot of packages locally compiled on my system. The G5 quad makes easy work of it.
I hope I have adressed your questions properly, this turned out to be quite a bit longer than I wanted it to be but this sort of thing gets me really enthusiastic and then I write way, way too much hah. I will happily answer any further questions.
P.S. : I just rebooted my ThinkPad and checked, my minimal graphical wayland setup idles just under 450MB of RAM on an empty desktop with 1 terminal window and no other applications open.