I'd steer more towards a used Xbox 360 controller due to price, robustness and compatibility.
That's a good point actually. First party controllers in general up until about the 8th gen were quite robust. The conspiratorial part of my brain makes me think this is a result of planned obsolescence, but i think it's more likely a result of manufacturers trying to cram more hardware into the same amount of space. It's funny to me that there are Atari 2600 and NES controllers floating about in the world that work as well as they did 40 odd years ago. Then again they're mechanically very simple, OG NES controller is basically super-cut-down membrane keyboard wedged between a particularly child resistant piece of plastic. Atari 2600 controllers are simple enough that a person with rudimentary electronics can
build their own. Hell, people have
built their own 2600 console from scratch with off the shelf parts (with the exception of the TIA, CPU and Ram/IO timer).
What's the compatibility like?
There are ways to use (to the best of my knowledge) almost every popular video game controller on a PC. There are a couple of generic Dualshock adapters which the Chinese manufacture. I used the "single port" adapter. There also exists a "Multitap" version made out of transparent blue plastic which i never needed, as I am a friendless loser.
OS compatability is for the most part is "plug and play". I'm a Linuxfag, so i never used these things extensively on Windows. The adapter seems to identify itself as a generic gamepad - on Linux this is handled by kernel out of the box, so it maps the pad to /dev/input/joyX or whatever - I assume that similar things would happen on Windows 10. IIRC Windows should pull the driver automatically, if it's not already supported in the kernel directly. No idea if this shit works on Mac, but i'd doubt it. Apple has limited hardware support for configurations that don't involve taking cock in your ass.
Game compatibility is decent. I bought the adapter for emulation, and every emulator that i remember using detected it without me needing to do any special configuration. I would expect the Windows experience to be the same. You're testing my memory here, but i vaguely recall using it on steam with some success. I believe steam emulates generic pads as an Xbox 360 controller, so any game on steam with Xbox 360 controller support "should" work. Given that the adapter is the same price as a fancy cup of coffee I'd say just take the plunge if you already have a DS2. You don't really have much to lose except time.
The PC Gaming Wiki, to my pleasant surprise, has rather comprehensive documentation on connecting various console controllers to a PC. If you want to go down this route further I'd suggest checking it out.