I have a SCUF Reflex PS5 controller. I have only confirmed this to work on Darktide and Dead Island 2, haven't done other games yet.
On 'Native Mode' if you go to 'Conntroller' > R2 (for example) and checked 'Turbo', nothing would happen in game. To get Turbo to work, I went back to 'Home' and under 'Virtual Device' I chose 'Xbox 360 Emulation', however it seems that turbo only work if you light press it, holding down the trigger does the heavy attack.
To remedy that issue create profiles for Adaptive Triggers, under Right Trigger I chose Feedback, Start position is where the light attack will register, for Darktide It's at 4. Resistance Strength is whatever you feel comfortable, I left mine at 4. With these settings, you can rest your finger to easily spam light attack and do heavy without much effort.