Not sure if I can help, I’m quite novice but figure I’d brainstorm some troubleshooting.
Could it be related to power saving features of the chipset or overheating?
Is it only dropping while in use and at set intervals? Or if it’s idle or using little power for basic browsing, does it work for long periods and then suddenly fail as soon as you start a big download? Is it only dropping while downloading from steam or does it do the same if you were to download a volume of files saturating the connection? If you were to stream a few 4k YouTube videos, maybe simultaneously, does that make it drop out?
What speed is the router/AP you are connecting to? Is it wifi 7? Is the signal strong? Have you tried connecting to 2.4Ghz instead of 5Ghz and if so, does the problem persist? Any issues with other devices in the network? Is the router/access point overloaded with too many devices (I personally had this issue in the past, with too many wifi devices slowing my router and dropping connections randomly).
Have you tried connecting to another router? I presume this is a desktop so can’t take it to a public space, so maybe even your phone hotspot if available to use could be used to eliminate that as the issue?
Don’t think it matters, but which DE? This is anecdotal but I have a device on bazzite gnome with another Realtek chipset and no issues. It was previously on Nobara KDE, and if there were multiple wifi devices in close proximity, this laptop’s wifi would slow to a halt and was unusable. The fix was likely related to a newer kernel included with the change to bazzite.
Hope something here helps.