Same issue here:
13' M2 2022
Sonoma 14.0
It's also hit or miss with me. Sometimes it works first try, others a disconnect reconnect does the trick. Others I can't get it to work at all.
I'm using GPTK to run Steam through Whisky, I can actually see the controller in Wine Settings but it receives no inputs.
Hope this gets fixed soon :')