After banging my head against the wall for years with this suspend issue, I found the culprit and fixed it: Dodocool USB-C PCI express card

For years, my computer (spec in the bottom) would have issues when sleeping/suspending. It would sleep and immediately wake up, but freeze, sometimes running fans at top speed until force-turned-off.
I've tried looking at logs and had found some solutions that would sometimes work, including disabling all /proc/acpi/wakeup devices.

Ultimately, I understood the issue came from the dodocool card mentioned. Once removed, it permanently fixed the issue.

kernel: ahci 0000:02:00.1: AHCI 0001.0301 32 slots 6 ports 6 Gbps 0x3f impl SATA mode port does not support device sleep ... SATA controller : Advanced Micro Devices, Inc. [AMD] 500 Series Chipset SATA Controller (prog-if 01 [AHCI 1.0])

"0000:02:00.1" this can change from user to user.

I'm leaving this post here for future reference in case anyone else has this same issue. Please recommend any other information I should add in order to help others.

Reference: