Personally, I don't use the gyro functionality but ds4 really shines on PC thru steam/ds4windows, much more so than on a ps4.
On the other hand Xbox controller is plug and play on PC, so it has that going for it
Yep. DS4 is in a weird middle ground between Steam Controller and Xbox controller.
Having used all options (except for Nintendo's offering), Xbox offers the best controller on PC for plug n play functionality across all storefronts for people who are already accustomed to analog sticks in all genres or want to use it for games which rely less on camera controls and aiming.
DS4 is good for people who want to avoid analog stick and get gyro functionality and can't get their hands on a Steam controller now. But you have to use 3rd party softwares for compatibility which can get iffy at times. Not to mention the on screen prompts won't always match and DS4 has terrible battery life even with lowering lightbar through settings.
Steam controller is by far the best option if you have already decided to tinker around with software for compatibility. The controller API gives you full customizable controls leading to almost infinite possibilities. Even though other controllers are compatible with the API, the lack of back pedals, dual stage triggers, and track pads limits the possibilities greatly. DS4 is essentially a vastly inferior Steam Controller and a slightly higher polling rate can't overcome the short comings of missing hardware functionality that Steam Controller provides (that too at a lower price point for people who already purchased it).
Most important deduction here then is, that the right analog stick can go and cry in a corner for eternity. No place for this archaic and sluggish input method for shooters, camera and cursor control in games.