I use a PS4 controller on my Windows 10 PC which is working fine. However I was at the same point as you.
The solution to my problem was working over Bluetooth.
I use the Asus USB-BT400 stick to connect with the controller.
When you connect your DualShock 4 controller to a PlayStation 4 via a USB cable, the controller automatically pairs with the console. To connect your PlayStation 4 controller with a PC, you’ll need to put it in Bluetooth pairing mode.
make sure to reset the controller (if already connected to another device)
press the "PlayStation" button and the "Share" button together until the lightbar starts flashing white to enter pairing mode.
go to your Bluetooth settings on the computer and try to connect the controller. If it is not shown try to restart the Bluetooth on your computer.
This is how it worked for me. Most games are working fine. However, sometimes it shows the xBox controlls ingame.
Here you can find some usefull tips.
Let me know about your results or tell me if something is unclear, hope this helps. Greets
Today I‘m always using the open source tool DS4Windows because I ran into troubles using my dualshock controler in some games, mainly struggled with Steep. You can download it from Github: