Gyro aiming, once you get the hang of it, is pretty great for fine tuning your aim. You do the large movements with the stick, then fine tune with the gyro. With practice it's very effective.

Basically any first person shooter is better for me with gyro aiming. I’m slightly more accurate with a mouse, but I prefer controller, so gyro aiming is next best. Specifically I play a lot of GTA, and you can tell Steam to translate gyro into joystick movement when you’re holding the left trigger down, and that lets you use gyro aiming in GTA. Some games (like Control) you can tell it to translate into mouse movement, which is the most precise, but GTA doesn’t let you use mouse and controller at the same time, so it gets really confused if you do that.

The rumble works fine on PC. It’s not nearly as good as it is on a PS5, but it does at least rumble. The adaptive triggers don’t work in PC on any game I’ve tested, so they just function like normal analog triggers.

The pad is completely useless, and actually gets in the way. It sends mouse movement to the game, and there’s no way to stop it (because the DualSense driver is what sends mouse input, so Steam Input doesn’t see it as controller input to translate it), so it can make games like GTA confused when you accidentally brush it. You get used to avoiding it though. If a game has native support for DualSense, then it’s actually useful, but then you also usually don’t get gyro aiming (unless the game also natively supports that).

But don’t take any of these gripes as anything other than nit picking. These minor things are my only problems with the controller, and every other controller I’ve tried has bigger/worse problems. (Examples: Xbox controller doesn’t have gyro, Switch Pro controller has digital triggers)