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.
Overhead projectors don’t exist anymore, they’ve been replaced by video projectors mounted overhead.
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’d suggest trying out Bazzite Linux. It’s the closest to SteamOS and has a lot of tweaks already installed.