If you can get a controller with Hall effect sensor that would be top. Else just get an Xbox series controller and call it a day. If you’re generally ruff with your joystick, you might look into cheaper controller, as all with no hall joysticks might start to drift earlier.
I’m very happy with my xbox series controller but others have less luck. But my mainboard has Bluetooth, so I can easily connect the controller. Some say you need the adapter, but I don’t, probably because it uses the newest Bluetooth version protocols.
The best controller was my original Xbox cable controller. It lasted me 15 years or more.