I use a PS4 controller on my PC. I don't have any trouble with it when I play Steam games, because Steam has its own native gamepad support, but non-Steam games need external driver software. I use DS4Tool which works fine, but it's not as simple as I'd like it to be. However, in both cases, games tend to not support PS4 button layouts, so instead of the X and Circle buttons, for example, you'll see A and B buttons. It's not too much of a bother but as someone who grew up only playing Playstation games, I sometimes don't make the connection between the A logo and the X button, if that makes sense.

I haven't used it, but people seem to be quite happy with the Xbox One controller for PC. Because it's a Microsoft product that supports xinput, it works on pretty much everything out of the box, so you don't need to bother with drivers. I just think that having the d-pad to the right of the left stick is super weird.

People also seem to like to use 8BitDo controllers for PC. Again, I haven't used one. They're designed to mimic the old style controllers while retaining modern controller features. They might also be cheaper and just as good as the more expensive xbox/ps4 pads.

You can use Switch joy-cons or the pro controller on PC, too. Might be good if you already own em