RAM is a horrible indication of phone performance imo.

The A15 chip in the iPhone 3 SE absolutely destroys the Dimensity 6300 chip in the 8GB phone you linked

A lot of people had liked iPhone because for the longest time android phones were not able to compete in the cpu/gpu space especially around the time of the iPhone 11.

Although now at the high end android phones are much closer together in performance so it’s more about what features you care about more between the phones.

This is a specific issue with several of the amd 500 series gigabyte motherboards, the only workaround is to disable GPP0 wakeup

You have to disabled it again every reboot so you will have to find a way to disable it automatically on boot

If I am not mistaken the GTS 450 should be more than powerful enough especially by Linux standards.