I want to know if there is a centralised community site where all Hardware is listed in terms of compatability with Linux. Something like AppDB for Wine.
Centralized, I don't think so.
But maybe this one is something you are looking for:
There are some other sites:
And an older list:
And most likely there are compatibility lists on every major distributions' site/forum, and some specialized sites like for TV-tuners:
A database of Linux-compatible computers & devices: https://linux-hardware.org/
Timeline of tested computers: https://linux-hardware.org/?view=timeline
A tool to analyze and count your computer: https://github.com/linuxhw/hw-probe
I'm the author of this project, so feel free to ask any questions in comments!
Linux Hardware Guide looks like a good resource.