Fedora is great on my Mac Pro 5,1 hardware.Fans are working perfectly on my Mac Pro 5,1 6-core 32GB Radeon RX580 8GB under Fedora 40 Kinoite (KDE Plasma, immutable OS) install.
I also have all my USB ports back at last (most of them stopped working reliably under OpenCore BigSur). I also have no issues with audio, both Spotify (app) and Qobuz (browser) sound great through the built-in headphone jack. Will be trying some DACs soon.
Apple trackpad works great straight out of the box, just have to plug it in. Huge win. Turn off natural scrolling and off to the races (I don't use gestures, I like to keep it simple).
I didn't find any Mac hardware complaints, only good news, when researching Fedora. I prefer long term stability and LTS versions, but Fedora offers more drivers than the downstream versions (CentOS, RHEL, AlmaLinux).