Yes, from my personal experience:

It’ll be a lot faster.

Edit: there’s ollama-cuda on the repos and alpaca-ai on the AUR, but I changed from the self managed to use the local ollama server. For games, there’s lutris, wine-cachyos, proton-cachyos, dxvk-mingw-git and vkd3d-proton-mingw-git all on the repos, so dxvk and vkd3d (the translation layers from directx to vulkan) are updated when the system is updated, but need to be installed with the provided scripts to work automagically after that.

Oracle database should have only one destination: The garbage bin

It just moved to gitflic and now requires a manual install on their .xpi file.

What is the cpu? If something, zswap (250mb) with lz4 and zram (2gb on disk) with lz4 too, on a lightweight distro on btrfs with lzo compression might make it usable. Disk compression might make it usable on the disk side and memory compression might make it run at least not extremely bad on the cpu side. Maybe cachyos with gnome (i know, but it is the only DE with good touchscreen) can be at least usable.

If more things, I can try to help. I have a linux tablet.

Edit: Maybe more space (external sd card with btrfs and lzo) could be used as /home too, but only with more information given, what is the setup?

Edit: My config that I made it work and run decently:

A lot of gamers want better performance, so a performance oriented distro with gaming quality of life features fills that gap. And ultimately there are a lot of YouTube channels promoting it and it kind of turned into a cool distro to use. This might explain the phenomenon.