I gave linux multiple tries using a couple different distros over the years and just found it to be less convenient and a lot more confusing. For general use it was fine but once I started messing around with different more niche programs and stuff it just got confusing. Sometimes stuff would only listed install instructions for Arch Linux and the build I used was debian so I was kind of out of luck on that. When I tried using Arch Linux I started running into the opposite issue, some apps would only list debian install instructions.
I've already put in the work to disable a bunch of the annoying bloatware with Windows 10 and I already what I'm doing on there.
I don't see the point in taking the time and effort to really learn Linux and use it as my main OS when I'm still gonna have to dual boot and keep windows installed if I wanna play games that use easy anticheat.
I've got my steam deck and I do use Linux mint on an old laptop I use for general web browsing and VLC but that's about as deep as I'm willing to really go. For now at least.
Your talking about AUR and .deb stuff, .deb is just flatpak usually and if you have a flatpak resolver you can install them on arch based distros, or just use applimages if you want a portable executable, personally i usually use the discover store for the rare flatpak i want to install on my garuda (arch based) linux.
ALL packages will work on linux, even aur if you hack it in will work on debian, though i'd suggest not using it that way as it likely would break if the release isn't bleeding edge (i'll explain later).
I'll be honest, alot of what your talking about also put me off of linux for nearly a decade, i'd try every year or so, get annoyed by something and quit, until i finally jumped at the end of 2024.
The main thing to keep in mind is that arch, debian and fedora are all essentially just updater cycles of linux that most linux versions use, as such anything that works on one will work on another and vice versa if you install the proper libraries, flatpak and applimages work on all versions of linux, even gentoo which is a version not of the big 3, the aur can also be configured to work on other distros but the aur uses the bleeding edge update schedule while debian and fedora/red hat use more long term schedules relatively, which is why it's generally not recommended to use AUR packages on non arch based distros, they are less likely to work as the programs are updated with the newest features such as kernel changes and code updates.
The biggest hurdle i had when it came to linux is understanding that all these linux "os" like mint, garuda, ubuntu, omarchy, endeavor, bazzite etc, are all just 1 os, linux, built with some programming tools pre-installed to make the user experience simpler and easier, they aren't operating systems in themselves but just linux versions built with specific functionalities in mind.
If you ever want to try again, i'd suggest just asking in the pc gaming section, there's quite a few of us who went through what you did with linux and can give you pointers if you have trouble, linux is pretty simple to use, but it's confusing because of how many options and false information is out there.