The Pi4 and Pi3 are different hardware and have different USB controllers, hence the difference. That's not why your controller behaves this way.
There must be some difference somehow. I tried 2 different controllers: Xbox One Series X controller and Xbox One S controller ("S" not "Series S"). I tried all 4 usb ports. Everything work fine on my Pi 3 but none of them get turned on when my Pi 4 boot.
I think I will move on, anyway I planned to use the Xbox One wireless dongle and buy batteries + a docking station for refilling the batteries, so this problem shouldn't bother me anymore after that. I'm just leaving as much information as possible in case someone else encounter the same problem in the future.
From a terminal please do rm /opt/retropie/configs/snes/retroarch.cfg or delete the file over windows networking
Go to Emulation Station -> RetroPie and do Update RetroPie-Setup script
Go to Manage Packages -> Main section > lr-snes9x-next - and choose "Update from binary"
and all should be good.
Oh I see. I assumed as the Logitech F710 switch had to be set to X input rather than D that this issue was effectively the same as mine. I'll start a new thread when I decide to have another attempt and if the problem resurfaces. Many thanks. :-)