I'd suggest trying out Bazzite Linux. It's the closest to SteamOS and has a lot of tweaks already installed.

NixOS Arch SteamOS Debian

Snapdragon is an ARM CPU which means if you can find a distro to run on it, it'll likely be an Android custom ROM, whereas Celeron is x86 and should run most Linux distros without issue.

The package is just a systemd unit to run the command python zenstates --c6-disable so if you install the zenstates-git package and get runit to run that command at startup it would be equivalent.

I have a system with a Ryzen 1700 with the same issue and have found the only reliable way to run it is by installing and enabling the disable-c6-systemd package from the AUR. The other fixes provided in the wiki article you linked are correct but aren't sufficient on my system, the CPU keeps reenabling the C6 state on its own and the disable-c6-systemd package works to counter that. The reason it works on Windows is they've disabled the C6 state by default for the CPU.

Caldera Open Linux 2.(?) back around 98/99, for long enough to download Slackware and Win98SE.

Overhead projectors don't exist anymore, they've been replaced by video projectors mounted overhead.

Same here. I came for the integrated ZFS support and stayed for the declarative config.

It's even easier to prevent confusion if you use /dev/disk/by-id/ id's, it only took a few times of overwriting the wrong disk to figure that out.

I did not know I needed to see that before today.

This IS the answer, everyone else is justifying it after the fact or just making shit up.