Keep in mind that you'll only find results from people who have issues. Few people will go online just to say their hardware works with Linux.
To give a concrete recommendation for a wifi adapter, look at Intel-based hardware. Intel stuff generally works out of the box because they contribute drivers to the Linux kernel directly. The ASUS PCe-AXE58BT is based on Intel's AX200 so should work out of the box on any modern Linux distro.
You basically never have to compile kernel modules anymore. Even if compilation is necessary, DKMS-based packages mean that the recompilation is done when you install your package updates, so you don't need to think about it.