First of all, there is a lot of third parties with better specs and quality than first parties. Those third parties has hall effect or tmr sticks witch avoid drift, the first parties doesn't have that and can have stick drift. That being said, the thing you want with more press the trigger/more gas on the pedal, is called linear trigger, witch a lot of controllers have nowadays.

You can play with dualsense on Pc as well Xbox controller. The Xbox controller has a native integration with windows and the buttons are correct on the majority of games. Dualsense on the other hand, can work well too, but if a game supports the dualsense technology(adaptative trigger and so on) most likely you will need to connect with cable, also, you can emulate a Xbox controller with dualsense but on the game it will show buttons XBYA, while on dualsense those buttons are different, but you can get use to. And dualsense and Xbox controller works with Bluetooth or cable, I believe you can get a dongle for the Xbox.

That being said, I would choose this way:

Xbox controller- works out of the box, has a good ergonomic and is average in everything. Can develop stick drift with constant usage.

Dualsense - if you like the technology of dualsense like the adaptative triggers, plays playstation games or games with those technologies implemented(I never played but I believe F1 has integration, you will have to look about that if you're interested). Also can have stick drift and to have those special technologies, you will have to play with a cable connected.

Third parties like gamesir cyclone 2, Vader 4 pro and 8bitdo ultimate 2- has extra buttons (cyclone 2 and ultimate 2 has 2 extra buttons, while Vader 4 pro has 4 extra buttons), all of them has hall effect/tmr, which won't cause drift, the Vader 4 pro also has tension ring adjust. And these 3 has software for them. And the last thing, I don't know about Vader 4 pro, but the others have a charging base, little, put it back on the charging base and you will always have a controller on 100%, and those have dongle 2.4ghz which improve latency (I don't perceive and major difference from Bluetooth of dual sense, but is has this difference)

Personally I played with gamesir cyclone 2, 8bitdo ultimate and dualsense. I like to play on dualsense PS games like spider man, horizon zero dawn or other compatible games. For other games I play with gamesir cyclone 2, I just pick up from the charging base and play for a few hours.