Only if the manufacturer provides the appropriate OS driver for it. Your statement that Linux should support an adapter more than 10+ years old out of the box is incorrect.
BTW, it's the legacy support for everything that keeps Windows from being as good of an OS as Mac and Linux.
No, the adapters are not 10 years old (more like 2) but there are drivers for such that go back as far as Vista.
" BTW, it's the legacy support for everything that keeps Windows from being as good of an OS as Mac and Linux."
Rather, as Linux forums well attest relative to the small percentage of Linux users, it is the lack of compatibility in Linux, plus the lack of comparable software for customization (without learning to code), that keeps Windows from being as good of an OS as Windows.